Validating our query
The same techniques we use to explore the data can be used to validate queries. By using the query as a subquery, you can run exploratory techniques to confirm the query results are as expected.
In this exercise, you will create a query that shows Bronze Medals by Country and then validate it using the subquery technique.
Feel free to reference the E:R Diagram as needed.
Deze oefening maakt deel uit van de cursus
Reporting in SQL
Interactieve oefening met praktijkervaring
Probeer deze oefening door deze voorbeeldcode aan te vullen.
-- Pull total_bronze_medals from summer_games below
SELECT ____ AS total_bronze_medals
FROM ____;