#115

Rooms Booked on September 2, 2019

Facilities is planning the cleaning schedule and needs to know how many physical rooms were actually used for appointments on September 2, 2019. Return the count of distinct room numbers (room_no) in Appointment on that date. Note: room_no is the physical room number; ward_code is the department code (e.g. CARD-A). One department can have several rooms, and the same room can host more than one appointment in a day.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.

count
6

Your query result will appear here