SQL/SQL입문하기

SQL_입문_01

explosion149 2024. 10. 26.

SELECT *

FROM food_orders fo

 

-- 특정 부분 선택

SELECT

fo.restaurant_name

as

'음식점' ,

fo.addr

as

'주소'

FROM

food_orders fo

 

SELECT

fo.order_id

'ord_no',

fo.price

'가격',

fo.quantity

'수량'

FROM

food_orders fo

 

SELECT

c.name "이름",

c.email "이메일"

FROM customers c

 

SELECT *

from food_orders fo

WHERE fo.cuisine_type ='Korean'

댓글

💲 추천 글