introducation to joins

SQL session 8

SELECT * FROM `students`
SELECT * FROM `students`
SELECT * FROM `students`
SELECT * FROM `students`
SELECT * FROM `students`
INSERT INTO students(first_name,last_name,dob,gender) VALUES ('Charles','Kasasiira','1999-04-12','male'),('David','Anyiiru','1999-05-12','male'),('Daniel','Awiiyo','1996-06-13','male'),('David','Wampamba','1990-12-12','male')
SELECT * FROM students
SELECT * FROM `results`
SELECT * FROM `results`
SELECT * FROM `results`
SELECT * FROM `results`
SELECT * FROM `results`
SELECT * FROM `students`
SELECT * FROM `results`
SELECT * FROM `students`
SELECT * FROM `students`
SELECT * FROM `students`
INSERT INTO `results`( `subject`, `marks`, `student_id`) VALUES ('Maths',91,3), ('SST',78,3), ('Science',86,3), ('English',85,3), ('Maths',94,6), ('SST',75,6), ('Science',91,6), ('English',83,6), ('Maths',90,7), ('SST',80,7), ('Science',50,7), ('English',60,7), ('Maths',70,8), ('SST',78,8), ('Science',40,8), ('English',85,8), ('Maths',89,9), ('SST',70,9), ('Science',60,9), ('English',75,9)
SELECT * FROM `results`
DELETE FROM results WHERE id = 3
SELECT * FROM `students`
SELECT * FROM `results`
SELECT students.id, students.first_name, students.last_name, students.gender, results.subject, results.marks FROM students INNER JOIN results ON students.id = results.student_id
SELECT students.first_name, results.subject FROM students INNER JOIN results ON students.id = results.student_id
SELECT * FROM students INNER JOIN results ON students.id = results.student_id