Filtering a column-oriented database

Similar to before, you'll query data from the olympic_medals table using Snowflake, this time, filtering the table to only show a subset of rows. A connection object has been created, which is stored in the variable conn. Good luck!

Cet exercice fait partie du cours

Introduction to NoSQL

Afficher le cours

Instructions

SELECT the team, name, and year columns (in that order) from the olympic_medals table.
Filter the dataset to only return rows after the year 2000.
Execute the query stored in the query variable, and print the results.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

# Return team, name, and year for all years greater than 2000
query = """
SELECT
	____,
    ____,
    ____
FROM olympic_medals 
WHERE ____
;
"""

# Execute the query, print the results
results = conn.cursor().____(____).fetch_pandas_all()
print(____)

Modifier et exécuter le code