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

Pyyhkäise näyttääksesi valikon

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.

Tehtävä

Swipe to start coding

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

Ratkaisu

Switch to desktopVaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista
Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 1. Luku 2
single

single

Kysy tekoälyä

expand

Kysy tekoälyä

ChatGPT

Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme

close

Awesome!

Completion rate improved to 33.33

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.

Tehtävä

Swipe to start coding

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

Ratkaisu

Switch to desktopVaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista
Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

close

Awesome!

Completion rate improved to 33.33

Pyyhkäise näyttääksesi valikon

some-alt