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!

Deze oefening maakt deel uit van de cursus

Introduction to NoSQL

Cursus bekijken

Oefeninstructies

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.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

# 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(____)

Code bewerken en uitvoeren