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.
This exercise is part of the course
Reporting in SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Pull total_bronze_medals from summer_games below
SELECT ____ AS total_bronze_medals
FROM ____;