Xero's product discovery team is testing a catalog reporting pattern for grouped product data. Using the game catalog below, write a PostgreSQL query that counts short games for every console.
Use a threshold of 10 hours, and treat a game as short only when playtime_hours < 10. Consoles with no qualifying games must still appear with a count of zero.
Requirements
- Join consoles to their game mappings and game details.
- Count each qualifying game at most once per console, even if duplicate mappings exist.
- Include consoles with no matching or qualifying games, and order the output alphabetically by console name.
