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.

idhas_wifi
1YES
2YES
3YES

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid