Engineering

Retrieve students who register for all levels of a course (that is, there is a registration for every level of a course for that student). Order by ssn. Result has schema (ssn, school, course). Write a mysql querry registrations | 1 ssn | school course +------+- | 2222 | Jacque's Culinary Adventure | Pastries | 2222 | French Academy | Croissants 3333 | Hans's Haute Cuisine Bavarian | 3333 | Jacque's Culinary Adventure | Pastries | 8888 | Hans's Haute Cuisine Bavarian +----------- 5 rows in set (0.001 sec) | 1 1 courses code cs1 cs2 CS3 cs4 cs5 fc1 2222 jpl school Charlie's Cooking School Charlie's Cooking School Charlie's Cooking School Charlie's Cooking School Charlie's Cooking School French Academy course Sausages Sausages Sausages Sausages Sausages Croissants level 1 2 3 4 5 1 description Hot Dogs Bratwurst Chorizo Kielbasa Andouille A terminal course in Croissant Construction Pretzels and Sauerkraut Croissants Macarons Pasta and Gnocchi ssn code classdate balance 1111 cs! 2016-01-10 170 1111 cs2 2016-01-11 800 1111 cs3 2016-01-12 240 1111 cs5 2016-01-14 | 1000 2222 cs1 2016-01-01 70 2222 cs2 2016-01-02 210 2222 cs3 2016-01-03 NULL 2222 cs4 2016-01-04 1234 2222fc1 2015-11-19 0 2016-01-15 0 2222 ip2 2016-01-16 0 3333 csl 2016-01-019 3333 cs3 2016-01-03 2000 3333 cs5 2016-01-05 5 3333 cs5 2016-01-148 3333 hb1 2016-01-08 8 3333 hb1 2016-01-17 0 3333 ipl 2016-01-06 NULL 3333 jp2 2016-01-07 11 8888 hb1 2016-01-088 credits 3 4 5 3 2 3 3 4 hb1 jp1 jp2 In 1 Hans's Haute Cuisine Bavarian Jacque"s Culinary Adventure Pastries Jacque"s Culinary Adventure Pastries Lorenzo's Lean Cuisine Napoli 1 1 2 | 1 4 4