彙總：摘要資料

以資料驅動的 SQL 決策制定

Bart Baesens

Professor Data Science and Analytics

彙總概覽

SELECT AVG(renting_price)
FROM movies;

SELECT AVG(renting_price)
FROM movies;

SQL 中的彙總函式：

SELECT COUNT(*)
FROM actors;

SELECT COUNT(name)
FROM actors;

SELECT COUNT(year_of_birth)
FROM actors;

SELECT DISTINCT country
FROM customers;

| country       |
|---------------|
| Spain         | 
| Great Britain | 
| Austria       | 
| Poland        | 
| ............. |

SELECT COUNT(DISTINCT country)
FROM customers;

SELECT DISTINCT rating
FROM renting
ORDER BY rating;

| rating |
|--------|
| 1      | 
| ...... | 
| 10     | 
| null   |

SELECT AVG(renting_price) AS average_price, 
         COUNT(DISTINCT genre) AS number_genres
FROM movies;

| average_price | number_genres |
|---------------|---------------|
| 2.21          | 8             |

以資料驅動的 SQL 決策制定