728x90
INSERT INTO books (title, author_fname, author_lname, released_year, stock_quantity, pages)
VALUES
('The Namesake', 'Jhumpa', 'Lahiri', 2003, 32, 291),
('Norse Mythology', 'Neil', 'Gaiman',2016, 43, 304),
('American Gods', 'Neil', 'Gaiman', 2001, 12, 465),
('Interpreter of Maladies', 'Jhumpa', 'Lahiri', 1996, 97, 198),
('A Hologram for the King: A Novel', 'Dave', 'Eggers', 2012, 154, 352),
('The Circle', 'Dave', 'Eggers', 2013, 26, 504),
('The Amazing Adventures of Kavalier & Clay', 'Michael', 'Chabon', 2000, 68, 634),
('Just Kids', 'Patti', 'Smith', 2010, 55, 304),
('A Heartbreaking Work of Staggering Genius', 'Dave', 'Eggers', 2001, 104, 437),
('Coraline', 'Neil', 'Gaiman', 2003, 100, 208),
('What We Talk About When We Talk About Love: Stories', 'Raymond', 'Carver', 1981, 23, 176),
("Where I'm Calling From: Selected Stories", 'Raymond', 'Carver', 1989, 12, 526),
('White Noise', 'Don', 'DeLillo', 1985, 49, 320),
('Cannery Row', 'John', 'Steinbeck', 1945, 95, 181),
('Oblivion: Stories', 'David', 'Foster Wallace', 2004, 172, 329),
('Consider the Lobster', 'David', 'Foster Wallace', 2005, 92, 343),
('10% Happier', 'Dan', 'Harris', 2014, 29, 256),
('fake_book', 'Freida', 'Harris', 2001, 287, 428),
('Lincoln In the Bardo', 'George', 'Saunders', 2017, 156, 375);
Having
-- 년도별 stock_quantity의 평균 값이 70보다 큰 책들의, 년도와 평균값을 보여주세요.
select released_year,avg(stock_quantity) as average
from books
group by released_year having average > 70;
'MySQL' 카테고리의 다른 글
MySQL - foreign keys 설정하기 (0) | 2022.12.08 |
---|---|
MySQL - case문과 if함수 사용하기 / 조건문 (0) | 2022.12.07 |
MySQL- is null : null인 데이터를 가져오는 방법 (0) | 2022.12.07 |
MySQL - date_format, 시간차이 datediff, 날짜 더하기date_add 사용하기 (0) | 2022.12.07 |
MySQL - 의 현재 Datetime 정보 가져오는 함수 curdate(), curtime(),now() (0) | 2022.12.07 |