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: Population Threshold Query
Here is the country table we are working with:
Opgave
Swipe to start coding
Write an SQL query to retrieve the name, population, region, and capital columns from the country table (please retrieve these columns in this order), returning only the countries with a population greater than or equal to 300000.
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 3. Kapitel 4
Challenge: Population Threshold Query
Here is the country table we are working with:
Opgave
Swipe to start coding
Write an SQL query to retrieve the name, population, region, and capital columns from the country table (please retrieve these columns in this order), returning only the countries with a population greater than or equal to 300000.
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 3. Kapitel 4
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder