RE:cord

[SQL] AVG / GROUP BY / ORDER BY DESC 본문

SQL

[SQL] AVG / GROUP BY / ORDER BY DESC

beie 2024. 11. 22. 13:55

<1>

SELECT AVG(no_of_likes) FROM fb_posts;

 

 

<2>

SELECT education, AVG(salary) FROM google_salaries GROUP BY education;

 

 

<3>

SELECT * FROM movie_catalogue ORDER BY duration DESC;

 

* Ascending: ORDER BY column / ORDER BY column ASC

* Descending: ORDER BY column DESC

'SQL' 카테고리의 다른 글

[SQL] Search for Data Containing Keywords (WHERE LIKE '%A%')  (0) 2024.12.03
[SQL] Finding the Nth Highest Values (JOIN/ORDER BY /LIMIT/DENSE_RANK () OVER)  (0) 2024.11.30
[SQL] Count the number of group (GROUP BY / JOIN / LEFT JOIN / SUM)  (2) 2024.11.27
[SQL] Find the Nth group (DENSE_RANK / OVER / SUBQUERY)  (0) 2024.11.24
[SQL] UNION / COUNT / BETWEEN  (0) 2024.11.22
'SQL' Related Articles more