๐Ÿ“–[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค] ์กฐ๊ฑด์— ๋งž๋Š” ๋„์„œ ๋ฆฌ์ŠคํŠธ ์ถœ๋ ฅํ•˜๊ธฐ

Chobbyยท2022๋…„ 12์›” 15์ผ
1

SQL

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

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

๋‹ค์Œ์€ ์–ด๋Š ํ•œ ์„œ์ ์—์„œ ํŒ๋งค์ค‘์ธ ๋„์„œ๋“ค์˜ ๋„์„œ ์ •๋ณด(BOOK) ํ…Œ์ด๋ธ”์ž…๋‹ˆ๋‹ค.

BOOK ํ…Œ์ด๋ธ”์€ ๊ฐ ๋„์„œ์˜ ์ •๋ณด๋ฅผ ๋‹ด์€ ํ…Œ์ด๋ธ”๋กœ ์•„๋ž˜์™€ ๊ฐ™์€ ๊ตฌ์กฐ๋กœ ๋˜์–ด์žˆ์Šต๋‹ˆ๋‹ค.

Column nameTypeNullableDescription
BOOK_IDINTEGERFALSE๋„์„œ ID
CATEGORYVARCHAR(N)FALSE์นดํ…Œ๊ณ ๋ฆฌ (๊ฒฝ์ œ, ์ธ๋ฌธ, ์†Œ์„ค, ์ƒํ™œ, ๊ธฐ์ˆ )
AUTHOR_IDINTEGERFALSE์ €์ž ID
PRICEINTEGERFALSEํŒ๋งค๊ฐ€ (์›)
PUBLISHED_DATEDATEFALSE์ถœํŒ์ผ

๐Ÿ’›๋ฌธ์ œ

BOOK ํ…Œ์ด๋ธ”์—์„œ 2021๋…„์— ์ถœํŒ๋œ '์ธ๋ฌธ' ์นดํ…Œ๊ณ ๋ฆฌ์— ์†ํ•˜๋Š” ๋„์„œ ๋ฆฌ์ŠคํŠธ๋ฅผ ์ฐพ์•„์„œ ๋„์„œ ID(BOOK_ID), ์ถœํŒ์ผ (PUBLISHED_DATE)์„ ์ถœ๋ ฅํ•˜๋Š” SQL๋ฌธ์„ ์ž‘์„ฑํ•ด์ฃผ์„ธ์š”.
๊ฒฐ๊ณผ๋Š” ์ถœํŒ์ผ์„ ๊ธฐ์ค€์œผ๋กœ ์˜ค๋ฆ„์ฐจ์ˆœ ์ •๋ ฌํ•ด์ฃผ์„ธ์š”.


๐Ÿ’š์˜ˆ์‹œ

์˜ˆ๋ฅผ ๋“ค์–ด BOOK ํ…Œ์ด๋ธ”์ด ๋‹ค์Œ๊ณผ ๊ฐ™๋‹ค๋ฉด

BOOK_IDCATEGORYAUTHOR_IDPRICEPUBLISHED_DATE
1์ธ๋ฌธ1100002020-01-01
2๊ฒฝ์ œ290002021-02-05
3์ธ๋ฌธ2110002021-04-11
4์ธ๋ฌธ3100002021-03-15
5์ƒํ™œ1120002021-01-10

์กฐ๊ฑด์— ์†ํ•˜๋Š” ๋„์„œ๋Š” ๋„์„œ ID ๊ฐ€ 3, 4์ธ ๋„์„œ์ด๋ฏ€๋กœ ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค.

BOOK_IDPUBLISHED_DATE
32021-04-11
42021-03-15

๊ทธ๋ฆฌ๊ณ  ์ถœํŒ์ผ ์˜ค๋ฆ„์ฐจ์ˆœ์œผ๋กœ ์ •๋ ฌํ•˜์—ฌ์•ผ ํ•˜๋ฏ€๋กœ ๋‹ค์Œ๊ณผ ๊ฐ™์€ ๊ฒฐ๊ณผ๊ฐ€ ๋‚˜์™€์•ผ ํ•ฉ๋‹ˆ๋‹ค.

BOOK_ID
4
3

๐Ÿ’™์ฃผ์˜์‚ฌํ•ญ

PUBLISHED_DATE์˜ ๋ฐ์ดํŠธ ํฌ๋งท์ด ์˜ˆ์‹œ์™€ ๋™์ผํ•ด์•ผ ์ •๋‹ต์ฒ˜๋ฆฌ ๋ฉ๋‹ˆ๋‹ค.


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

SELECT BOOK_ID, TO_CHAR(PUBLISHED_DATE, 'yyyy-mm-dd') AS PUBLISHED_DATE
FROM BOOK
WHERE TO_CHAR(PUBLISHED_DATE, 'yyyy') = '2021'
AND CATEGORY = '์ธ๋ฌธ'
ORDER BY PUBLISHED_DATE
;
profile
๋‚ด ์ง€์‹์„ ๊ณต์œ ํ•  ์ˆ˜ ์žˆ๋Š” ๋Œ€๋‹ดํ•จ

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