Wi-Fi availability by cabin

The cabin catalog card needs a clear Wi-Fi indicator: YES if internet is available and NO if it is not. For each cabin, return its ID and this string. The indicator column should be named has_wifi.

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. Your answer must use the same column names as this sample — alias them with AS if needed.

id	has_wifi
1	YES
2	YES
3	YES

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid