Kursusindhold
Introduction to SQL
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
Challenge: Continental Count
Here is the country table we are working with:
Opgave
Swipe to start coding
Write an SQL query to retrieve the number of countries from the Europe and Asia continents (where continent = Europe or continent = Asia).
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederVar alt klart?
Tak for dine kommentarer!
Sektion 5. Kapitel 4
Challenge: Continental Count
Here is the country table we are working with:
Opgave
Swipe to start coding
Write an SQL query to retrieve the number of countries from the Europe and Asia continents (where continent = Europe or continent = Asia).
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederVar alt klart?
Tak for dine kommentarer!
Sektion 5. Kapitel 4
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder