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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!