SQL Interview Questions
Test yourself with real SQL interview questions: Question 1 Given the table below, write a SQL query that retrieves the personal data about alumni who scored above 16 on their calculus exam. alumni student_id name surname birth_date faculty 344 Aishani Lopes 1990-04-26 Med School 345 Robert Roy 1990-03-09 Physics evaluate student_id class_id exam_date grade 344 74 2014-06-19 17 344 87 2014-06-06 20 345 74 2014-06-19 11 curriculum class_id class_name professor_id semester 74 algebra 430 2014_summer 87 calculus 531 2014_summer 46 statistics 626 2014_winter There can be different answers. This is one of them. SELECT a . name , a . surname , a . birth_date , a . faculty FROM alumni AS a INNER JOIN evaluate AS e ON a . student_id = e . student_id INNER JOIN curriculum AS c ON e . class_id = c . class_id WHERE c . class_name = 'calculus' AND e . grade > 16 ; Question 2 There is a beverages table. id na...