๐Ÿฌ[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค] ์ฆ๊ฒจ์ฐพ๊ธฐ๊ฐ€ ๊ฐ€์žฅ ๋งŽ์€ ์‹๋‹น ์ •๋ณด ์ถœ๋ ฅํ•˜๊ธฐ

Chobbyยท2023๋…„ 1์›” 2์ผ
1

SQL

๋ชฉ๋ก ๋ณด๊ธฐ
35/41

๐Ÿงก๋ฌธ์ œ ์„ค๋ช…

๋‹ค์Œ์€ ์‹๋‹น์˜ ์ •๋ณด๋ฅผ ๋‹ด์€ REST_INFO ํ…Œ์ด๋ธ”์ž…๋‹ˆ๋‹ค. REST_INFO ํ…Œ์ด๋ธ”์€ ๋‹ค์Œ๊ณผ ๊ฐ™์œผ๋ฉฐ REST_ID, REST_NAME, FOOD_TYPE, VIEWS, FAVORITES, PARKING_LOT, ADDRESS, TEL์€ ์‹๋‹น ID, ์‹๋‹น ์ด๋ฆ„, ์Œ์‹ ์ข…๋ฅ˜, ์กฐํšŒ์ˆ˜, ์ฆ๊ฒจ์ฐพ๊ธฐ์ˆ˜, ์ฃผ์ฐจ์žฅ ์œ ๋ฌด, ์ฃผ์†Œ, ์ „ํ™”๋ฒˆํ˜ธ๋ฅผ ์˜๋ฏธํ•ฉ๋‹ˆ๋‹ค.

Column nameTypeNullable
REST_IDVARCHAR(5)FALSE
REST_NAMEVARCHAR(50)FALSE
FOOD_TYPEVARCHAR(20)TRUE
VIEWSNUMBERTRUE
FAVORITESNUMBERTRUE
PARKING_LOTVARCHAR(1)TRUE
ADDRESSVARCHAR(100)TRUE
TELVARCHAR(100)TRUE

๐Ÿ’›๋ฌธ์ œ

REST_INFO ํ…Œ์ด๋ธ”์—์„œ ์Œ์‹์ข…๋ฅ˜๋ณ„๋กœ ์ฆ๊ฒจ์ฐพ๊ธฐ์ˆ˜๊ฐ€ ๊ฐ€์žฅ ๋งŽ์€ ์‹๋‹น์˜ ์Œ์‹ ์ข…๋ฅ˜, ID, ์‹๋‹น ์ด๋ฆ„, ์ฆ๊ฒจ์ฐพ๊ธฐ์ˆ˜๋ฅผ ์กฐํšŒํ•˜๋Š” SQL๋ฌธ์„ ์ž‘์„ฑํ•ด์ฃผ์„ธ์š”. ์ด๋•Œ ๊ฒฐ๊ณผ๋Š” ์Œ์‹ ์ข…๋ฅ˜๋ฅผ ๊ธฐ์ค€์œผ๋กœ ๋‚ด๋ฆผ์ฐจ์ˆœ ์ •๋ ฌํ•ด์ฃผ์„ธ์š”.


๐Ÿ’š์˜ˆ์‹œ

REST_INFO ํ…Œ์ด๋ธ”์ด ๋‹ค์Œ๊ณผ ๊ฐ™์„ ๋•Œ

REST_IDREST_NAMEFOOD_TYPEVIEWSFAVORITESPARKING_LOTADDRESSTEL
00001์€๋ผ์ง€์‹๋‹นํ•œ์‹1150345734N์„œ์šธํŠน๋ณ„์‹œ ์ค‘๊ตฌ ๋‹ค์‚ฐ๋กœ 149010-4484-8751
00002ํ•˜์ด๊ฐ€์ฏ”๋„ค์ผ์‹120034112N์„œ์šธ์‹œ ์ค‘๊ตฌ ์‹ ๋‹น๋™ 375-21NULL
00003๋”ฐ๋ ๋”ฐ๋ ๋œจ์–‘์‹1234023102N์„œ์šธ์‹œ ๊ฐ•๋‚จ๊ตฌ ์‹ ์‚ฌ๋™ 627-3 1F02-6397-1023
00004์Šค์‹œ์‚ฌ์นด์šฐ์Šค์ผ์‹1522074230N์„œ์šธ์‹œ ์„œ์šธ์‹œ ๊ฐ•๋‚จ๊ตฌ ์‹ ์‚ฌ๋™ 627-27010-9394-2554
00005์ฝ”์ŠŒ์Šค์ผ์‹15301123N์„œ์šธํŠน๋ณ„์‹œ ๊ฐ•๋‚จ๊ตฌ ์–ธ์ฃผ๋กœ153๊ธธ010-1315-8729

SQL์„ ์‹คํ–‰ํ•˜๋ฉด ๋‹ค์Œ๊ณผ ๊ฐ™์ด ์ถœ๋ ฅ๋˜์–ด์•ผ ํ•ฉ๋‹ˆ๋‹ค.

FOOD_TYPEREST_IDREST_NAMEFAVORITES
ํ•œ์‹00001์€๋ผ์ง€์‹๋‹น734
์ผ์‹00004์Šค์‹œ์‚ฌ์นด์šฐ์Šค230
์–‘์‹00003๋”ฐ๋ ๋”ฐ๋ ๋œจ102

๐Ÿ’™๋‚˜์˜ ํ’€์ด

SELECT
FOOD_TYPE,
REST_ID,
REST_NAME,
FAVORITES
FROM REST_INFO
WHERE FAVORITES IN (
    SELECT MAX(FAVORITES) FROM REST_INFO
    GROUP BY FOOD_TYPE
)
GROUP BY FOOD_TYPE
ORDER BY FOOD_TYPE DESC
profile
๋‚ด ์ง€์‹์„ ๊ณต์œ ํ•  ์ˆ˜ ์žˆ๋Š” ๋Œ€๋‹ดํ•จ

0๊ฐœ์˜ ๋Œ“๊ธ€