1. Learn
    2. /
  2. Courses
    3. /
  3. Reporting in SQL

Exercise

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.

Instructions 1/3

undefined XP
    1
    2
    3
  • Create a query that outputs total bronze medals from the summer_games table.