Computer scienceFundamentalsSQL and DatabasesBasics SQLRetrieving Data

Results ordering

Theory

Census

Report a typo

A table is defined by the following statement:

CREATE TABLE Census (id INTEGER, 
                     name VARCHAR(20), 
                     birth_year INTEGER, 
                     gender VARCHAR(1));

Write a query that selects all data from the table sorted by birth_year in descending order and by name in ascending order. Do not change the order of the columns.

Write an SQL statement





___

Create a free account to access the full topic