1. 회원 가입

insert into
Customer(customerID, password, name, birth, contact, address, createdAt, status)
values
(1, dfj3432425fdjklfa, 김예지, 19980101, 01012345678, 중부대로, 2022-11-06, 1);

2. 회원 정보 수정

update Customer set contact=01011111111 where name='김예지';

3. 가게 검색(Type으로 / 이름으로)

select storeName from Store where type='한식';

select storeName from  Store where storeName='솔티드';

4. 가게의 리뷰 확인

select c.imageUrl, c.name, r.content, r.star
from Review as r
	inner join Customer as c
	on r.customerId = c.customerId
where r.storeId=(select storeId from Store where storeName='솔티드')
order by createdAt desc; 

5. 메뉴판(추천 메뉴 보여주기)

select m.imageUrl, m.name, m.price
from Menu as m, Store as s
where m.type='추천메뉴' and s.storeId = m.storeId;

6. 메뉴 선택하기

insert into
SelectMenu (selectMenuId, menuId, customerId, count, amount)
select 1111, m.menuId, c.customerId, 2, m.price*count
from Menu as m, Customer as c
where c.customerId = 1 or m.menuId = '임의의 메뉴번호';

#selectMenuId나 구매 개수 count처럼 select문과 관계없는 것들도 이렇게 써도 되나?