-- create a table
CREATE TABLE students (
    student_id INT PRIMARY KEY,
    name VARCHAR(50),
    grade VARCHAR(50)
);
CREATE TABLE course (
    course_id INT PRIMARY KEY,
    course_name VARCHAR(50),
    s_id INT
);

-- insert some values
INSERT INTO students VALUES 
(1, 'Ryan', 'A'),
(2, 'Kevin', 'B'),
(3, 'Fred', 'A'),
(4, 'Tommy', 'D');


INSERT INTO course VALUES 
(101, 'Maths', 2),
(234, 'Science', 1),
(435, 'Literature', 5),
(212, 'Literature', 1);


-- SELECT * FROM students;
SELECT * 
FROM students 
JOIN course
ON student_id=s_id;

-- SELECT * 
-- FROM students
-- LEFT JOIN course
-- ON student_id=s_id;

-- SELECT * 
-- FROM students
-- RIGHT JOIN course
-- ON student_id=s_id;

SELECT *
FROM course
FULL JOIN students
ON student_id=s_id;

SELECT MIN(course_id)
FROM course;

SELECT COUNT(course_name)
FROM course;

-- SELECT MIN(course_name)
-- FROM course;