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!

Diese Übung ist Teil des Kurses

Introduction to NoSQL

Kurs anzeigen

Anleitung zur Übung

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.

Interaktive Übung

Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.

# 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 bearbeiten und ausführen