insert into
Customer(customerID, password, name, birth, contact, address, createdAt, status)
values
(1, dfj3432425fdjklfa, 김예지, 19980101, 01012345678, 중부대로, 2022-11-06, 1);
update Customer set contact=01011111111 where name='김예지';
select storeName from Store where type='한식';
select storeName from Store where storeName='솔티드';
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;
select m.imageUrl, m.name, m.price
from Menu as m, Store as s
where m.type='추천메뉴' and s.storeId = m.storeId;
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문과 관계없는 것들도 이렇게 써도 되나?