List the total slots booked per facility
Question
Produce a list of the total number of slots booked per facility. For now, just produce an output table consisting of facility id and slots, sorted by facility id.Schema reminder ▼
Your Answer
Answers and Discussion Show
select facid, sum(slots) as "Total Slots" from cd.bookings group by facid order by facid;
Other than the fact that we've introduced the SUM aggregate function, there's not a great deal to say about this exercise. For each distinct facility id, the SUM function adds together everything in the slots column.