Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Lære Failed task checker | first section new task ui sql course
test sql course e2e new task ui

Sveip for å vise menyen

book
Failed task checker

Let's explore this database a bit further. The country database consists of a single table named country. Let's examine the contents of this table.

This table has 15 rows, which means we have 15 distinct records for different countries.

Now, what about the columns? In this table, we have 7 columns, like id, name, continent, region, SurfaceArea, capital, and population.

  1. id - the record number in this table;

  2. name - the name of the country;

  3. continent - the name of the country's continent;

  4. region- the name of the country's region;

  5. SurfaceArea - the total land area of the country;

  6. capital - the capital of the country;

  7. population - the population of the country.

Oppgave

Swipe to start coding

You need to retrieve the continent column from the country table.

Løsning

Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 1. Kapittel 2

Spør AI

expand
ChatGPT

Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår

book
Failed task checker

Let's explore this database a bit further. The country database consists of a single table named country. Let's examine the contents of this table.

This table has 15 rows, which means we have 15 distinct records for different countries.

Now, what about the columns? In this table, we have 7 columns, like id, name, continent, region, SurfaceArea, capital, and population.

  1. id - the record number in this table;

  2. name - the name of the country;

  3. continent - the name of the country's continent;

  4. region- the name of the country's region;

  5. SurfaceArea - the total land area of the country;

  6. capital - the capital of the country;

  7. population - the population of the country.

Oppgave

Swipe to start coding

You need to retrieve the continent column from the country table.

Løsning

Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 1. Kapittel 2
Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Vi beklager at noe gikk galt. Hva skjedde?
some-alt