Please attach your work on terminal or Command Prompt

1. Consider the relation, r, shown below. Give the result of the following query: (4 points) 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