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 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in