12. Students and Examinations

SQL 50 Problems - Leetcode SQL questions solution

Create table If Not Exists Students_12 (student_id int, student_name varchar(20));
Create table If Not Exists Subjects_12 (subject_name varchar(20));
Create table If Not Exists Examinations_12 (student_id int, subject_name varchar(20));
Truncate table Students_12;
insert into Students_12 (student_id, student_name) values ('1', 'Alice');
insert into Students_12 (student_id, student_name) values ('2', 'Bob');
insert into Students_12 (student_id, student_name) values ('13', 'John');
insert into Students_12 (student_id, student_name) values ('6', 'Alex');
Truncate table Subjects_12;
insert into Subjects_12 (subject_name) values ('Math');
insert into Subjects_12 (subject_name) values ('Physics');
insert into Subjects_12 (subject_name) values ('Programming');
Truncate table Examinations_12;
insert into Examinations_12 (student_id, subject_name) values ('1', 'Math');
insert into Examinations_12 (student_id, subject_name) values ('1', 'Physics');
insert into Examinations_12 (student_id, subject_name) values ('1', 'Programming');
insert into Examinations_12 (student_id, subject_name) values ('2', 'Programming');
insert into Examinations_12 (student_id, subject_name) values ('1', 'Physics');
insert into Examinations_12 (student_id, subject_name) values ('1', 'Math');
insert into Examinations_12 (student_id, subject_name) values ('13', 'Math');
insert into Examinations_12 (student_id, subject_name) values ('13', 'Programming');
insert into Examinations_12 (student_id, subject_name) values ('13', 'Physics');
insert into Examinations_12 (student_id, subject_name) values ('2', 'Math');
insert into Examinations_12 (student_id, subject_name) values ('1', 'Math');


#leetcode #sql #data #dataengineers #datascience #dataanalytics #sqlinterviewquestions