MySQL - food 데이터베이스 만들기

2022-07-15(20일차)

📃 food 데이터베이스를 만들어보자

과자
제품 번호, 이름, 가격, 생산일, 유통기한, 회사, 맛, 칼로리

1. '20302849', '홈런볼', 1700, '2022-07-10', '2023-01-03, '해태', '초코', 270

2. '21904322', '매운 새우깡', 1200, '2022-04-01', '2022-11-14', '농심', '양념', 450

3. '21483229', '포카칩 어니언', 1500, '2022-04-27', '2022-11-25', '농심, '감자', 377

4. '22958228', '빼빼로 오리지널', 1500, '2022-05-12', '2022-12-02', '롯데', '초코', 225

5. '20132245', '에이스', 1000, '2021-02-02', '2022-04-07', '해태', '버터', 540

6. '23104933', '눈을 감자', 1200, '2022-03-12', '2022-09-10', '오리온', '감자', 287

7. '23918250', '꼬북칩 초코츄러스', 1500, '2022-05-12', '2022-12-28', '오리온', '초코', 532

8. '23817334', '카스타드', 2800, '2021-01-03', '2021-08-04', '오리온', '크림', 102

9. '21759382', '감자깡', '2022-01-26', '2023-03-01', '농심', '감자', 235

10. '20598432', '오예스', '2022-07-15', '2023-03-26', '해태', '초코', 150

11. '23109584', '고래밥', '2022-05-05', '2022-12-25', '오리온', '양념', 744

12. '23985823', '썬칩', '2021-02-09', '2021-11-01', '오리온', '양념', 690

13. '22381234', '웨하스', '2022-06-25', '2022-10-21', '롯데', '크림', 353

14. '21195948', '포스틱', '2022-05-15', '2022-11-29', '농심', '감자', 395

15. '20084821', '버터링', '2022-07-03', '2023-02-12', '해태', '버터', 410

---

create database food;

use food;

create table snack(
	no char(10),
   	name varchar(20),
    	price int,
   	prodution_date date,
    	shelf_life date,
    	company varchar(10),
    	flavor varchar(25),
    	calorie float
 );

insert into snack values (
	'20302849', '홈런볼', 1700, '2022-07-10', '2023-01-03', '해태', '초코', 270
);

insert into snack values (
	'21904322', '매운 새우깡', 1200, '2022-04-01', '2022-11-14', '농심', '양념', 450
);

insert into snack values (
	'21483229', '포카칩 어니언', 1500, '2022-04-27', '2022-11-25', '농심', '감자', 377
);

insert into snack values (
	'22958228', '빼빼로 오리지널', 1500, '2022-05-12', '2022-12-02', '롯데', '초코', 225
);

insert into snack values (
	'20132245', '에이스', 1000, '2021-02-02', '2022-04-07', '해태', '버터', 540
);

insert into snack values (
	'23104933', '눈을 감자', 1200, '2022-03-12', '2022-09-10', '오리온', '감자', 287
);

insert into snack values (
	'23918250', '꼬북칩 초코츄러스', 1500, '2022-05-12', '2022-12-28', '오리온', '초코', 532
);

insert into snack values (
	'23817334', '카스타드', 2800, '2021-01-03', '2021-08-04', '오리온', '크림', 102
);

insert into snack values (
	'21759382', '감자깡', 1500, '2022-01-26', '2023-03-01', '농심', '감자', 235
);

insert into snack values (
	'20598432', '오예스', 3000, '2022-07-15', '2023-03-26', '해태', '초코', 150
);

insert into snack values (
	'23109584', '고래밥', 1000, '2022-05-05', '2022-12-25', '오리온', '양념', 744
);

insert into snack values (
	'23985823', '썬칩', 1500, '2021-02-09', '2021-11-01', '오리온', '양념', 690
);

insert into snack values (
	'22381234', '웨하스', 2100, '2022-06-25', '2022-10-21', '롯데', '크림', 353
);

insert into snack values (
	'21195948, '포스틱', 1600, '2022-05-15', '2022-11-29', '농심', '감자', 395'
);

insert into snack values (
	'20084821', '버터링', 1200, '2022-07-03', '2023-02-12', '해태', '버터', 410
);

 select *
	from snack
	order by no asc;

select avg(price)
	from snack
	group by company;