Veritabanında sorgulama

Orta Düzey SQL

Jasmin Ludolf

Data Science Content Developer, DataCamp

Kurs yol haritası

PostgreSQL Logosu

Alan adları ve veri türleriyle birlikte films veritabanındaki dört tabloyu gösteren şema

SELECT COUNT(birthdate) AS count_birthdates
FROM people;

|count_birthdates|
|----------------|
|6152            |

SELECT COUNT(name) AS count_names, COUNT(birthdate) AS count_birthdates
FROM people;

|count_names|count_birthdates|
|-----------|----------------|
|6397       |6152            |

SELECT COUNT(*) AS total_records
FROM people;

|total_records|
|-------------|
|8397         |

SELECT language
FROM films;

|language |
|---------|
|Danish   |
|Danish   |
|Greek    |
|Greek    |
|Greek    |

SELECT DISTINCT language
FROM films;

|language |
|---------|
|Danish   |
|Greek    |

SELECT COUNT(DISTINCT birthdate) AS count_distinct_birthdates
FROM people;

|count_distinct_birthdates|
|-------------------------|
|5398                     |

Orta Düzey SQL