Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Challenge: Find All Countries | Retrieving Data
course content

Conteúdo do Curso

Introduction to SQL

1. Retrieving Data

Retrieving Individual ColumnsRetrieving Multiple Columns Retrieving All ColumnsRetrieving Distinct RowsLimiting ResultsChallenge: Find the Population of the CountriesChallenge: Find All CountriesChallenge: Find All Countries With Their IDsChallenge: Find Country CapitalsChallenge: Find the Regions in Which All Countries Are Located

2. Sorting Retrieved Data

Sorting DataChallenge: Population SortSorting by Multiple ColumnsChallenge: Dual-Sort QuerySpecifying Sort DirectionChallenge: Sort the Countries by Region and CapitalChallenge: Sort Capitals in Descending OrderChallenge: Sort Countries in Ascending OrderChallenge: Find Countries, Their IDs, and Their PopulationsChallenge: Find Countries, IDs, Populations, Regions, and Sort ThemChallenge: Find All Continents and Sort Them in Ascending Order

3. Filtering Data

Using the WHERE ClauseChallenge: North America Population SortThe WHERE Clause Operators Challenge: Population Threshold QueryChecking for a Range of ValuesChecking for NO Value

4. Advanced Data Filtering

Using the AND OperatorChallenge: Europe Region SortUsing the OR operatorChallenge: America Regions FilterUsing the NOT OperatorChallenge: Non-Europe Capitals Sort

5. Aggregate Functions

The AVG() FunctionChallenge: Large Surface Area AverageThe COUNT() FunctionChallenge: Continental CountThe MAX() FunctionThe MIN() FunctionChallenge: Surface Area SelectionThe SUM() Function

Introduction to SQL

Challenge: Find All CountriesChallenge: Find All Countries

Tarefa

Write an SQL query to retrieve the names of all countries (name column) from the country table.

Tudo estava claro?

Seção 1. Capítulo 7
toggle bottom row
course content

Conteúdo do Curso

Introduction to SQL

1. Retrieving Data

Retrieving Individual ColumnsRetrieving Multiple Columns Retrieving All ColumnsRetrieving Distinct RowsLimiting ResultsChallenge: Find the Population of the CountriesChallenge: Find All CountriesChallenge: Find All Countries With Their IDsChallenge: Find Country CapitalsChallenge: Find the Regions in Which All Countries Are Located

2. Sorting Retrieved Data

Sorting DataChallenge: Population SortSorting by Multiple ColumnsChallenge: Dual-Sort QuerySpecifying Sort DirectionChallenge: Sort the Countries by Region and CapitalChallenge: Sort Capitals in Descending OrderChallenge: Sort Countries in Ascending OrderChallenge: Find Countries, Their IDs, and Their PopulationsChallenge: Find Countries, IDs, Populations, Regions, and Sort ThemChallenge: Find All Continents and Sort Them in Ascending Order

3. Filtering Data

Using the WHERE ClauseChallenge: North America Population SortThe WHERE Clause Operators Challenge: Population Threshold QueryChecking for a Range of ValuesChecking for NO Value

4. Advanced Data Filtering

Using the AND OperatorChallenge: Europe Region SortUsing the OR operatorChallenge: America Regions FilterUsing the NOT OperatorChallenge: Non-Europe Capitals Sort

5. Aggregate Functions

The AVG() FunctionChallenge: Large Surface Area AverageThe COUNT() FunctionChallenge: Continental CountThe MAX() FunctionThe MIN() FunctionChallenge: Surface Area SelectionThe SUM() Function

Introduction to SQL

Challenge: Find All CountriesChallenge: Find All Countries

Tarefa

Write an SQL query to retrieve the names of all countries (name column) from the country table.

Tudo estava claro?

Seção 1. Capítulo 7
toggle bottom row
some-alt