Skip to content

Instantly share code, notes, and snippets.

@charles-tan

charles-tan/ds_gaming_use_case_6.sql

Created March 27, 2024 16:08
Show Gist options
  • Save charles-tan/77f309059b85655da15f036abdfd483a to your computer and use it in GitHub Desktop.
Save charles-tan/77f309059b85655da15f036abdfd483a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ds_gaming_use_case_6.sql
SELECT
*,
(CAST(games_won AS DOUBLE) / games_played) AS win_loss_ratio
FROM player_wins
ORDER BY win_loss_ratio DESC
LIMIT 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment