#114

How Many Cardiology Wards

The chief physician wants a quick stat: how many cardiology wards the hospital has. All of their codes start with the CARD prefix — count the number of distinct such wards. Name the result column wards_count.

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.

wards_count
3

Your query result will appear here