Question: 8. Consider the relation, r, shown below. Give the result of the following query: (4 points) You are supposed to create a table named r

8. Consider the relation, r, shown below. Give the result of the following query: (4 points) You are supposed to create a table named "r" in your own database and load the give records in the table below, then run the given SQL statement and submit the results to me. building room_number time slot id course_id sec id Garfield 359 A BIO-101 1 Garfield 359 B BIO-101 2 Saucon 651 A CS-101 2 Saucon 550 CS-319 1 Painter 705 A BIO-305 1 Painter 705 D MU-199 1 Painter 705 B CS-101 1 Painter 403 D FIN-201 1 SELECT building, room_number, time_slot_id, count(*) FROM GROUP BY ROLLUP (building, room_number, time_slot_id) In MySQL, use: SELECT building, room_number, time_slot_id, count(*) FROM GROUP BY building, room_number, time_slot_id with rollup
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
