JW Blog
SQL ํ™œ์šฉ (MySQL)

SQL ํ™œ์šฉ (MySQL)

Part 4. ๋ฐ์ดํ„ฐ์˜ ์ดํ•ด์™€ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค

๋ณธ ํฌ์ŠคํŒ…์€ ํŒจ์ŠคํŠธ์บ ํผ์Šค(FastCampus)์˜ ๋ฐ์ดํ„ฐ ์—”์ง€๋‹ˆ์–ด๋ง ์˜ฌ์ธ์› ํŒจํ‚ค์ง€ Online์„ ์ฐธ๊ณ ํ•˜์˜€์Šต๋‹ˆ๋‹ค.

1. Artist Data

1

SELECT genre, COUNT(*) FROM artist_genres GROUP BY 1 ORDER BY 2 DESC LIMIT 20;

2. Artist Genre Analysis with SQL

1
2
3

SELECT popularity, name FROM artists ORDER BY 1 DESC LIMIT 20;

SELECT genre, COUNT(*) FROM artists t1 JOIN artist_genres t2 ON t2.artist_id = t1.id WHERE t1.popularity > 80 GROUP BY 1 ORDER BY 2 DESC LIMIT 20;
  • join์„ ํ†ตํ•ด ERD์˜ ์žฅ์ ์„ ํ™œ์šฉํ•˜์—ฌ ๊ธฐ์ดˆ๋ถ„์„์„ ํ•  ์ˆ˜ ์žˆ๋‹ค.
๋ชฉ์ฐจ