Ordering by a single column

To sort the result output by a field, we use the .order_by() method. By default, the .order_by() method sorts from lowest to highest on the supplied column. You just have to pass in the name of the column you want sorted to .order_by().

In the video, for example, Jason used stmt.order_by(census.columns.state) to sort the result output by the state column.

Este ejercicio forma parte del curso

Introduction to Databases in Python

Ver curso

Instrucciones del ejercicio

Select all records of the state column from the census table. To do this, pass census.columns.state as a list to select().
Append an .order_by() to sort the result output by the state column.
Execute stmt using the .execute() method on connection and retrieve all the results using .fetchall().
Print the first 10 rows of results.

Ejercicio interactivo práctico

Prueba este ejercicio y completa el código de muestra.

# Build a query to select the state column: stmt
stmt = ____

# Order stmt by the state column
stmt = ____

# Execute the query and store the results: results
results = ____

# Print the first 10 results
print(____[:10])

Editar y ejecutar código