Tra cứu cơ sở dữ liệu

SQL nâng cao

Jasmin Ludolf

Data Science Content Developer, DataCamp

Lộ trình khóa học

PostgreSQL Logo

Sơ đồ thể hiện bốn bảng trong cơ sở dữ liệu phim, bao gồm tên trường và loại dữ liệu

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                     |

SQL nâng cao