Exercise · SQL & Querying
Predict, then run it
Predict the output
prizes(payload) JSON with scores 85 and 9. Order the leaderboard numerically — cast after extraction:
SELECT CAST(json_extract_string(payload, '$.score') AS INT) AS score FROM prizes ORDER BY CAST(json_extract_string(payload, '$.score') AS INT);
Predict the exact output.