[SQL문제풀기] Order Details

문제

StrataScratch - Order Details

StrataScratch

https://platform.stratascratch.com/coding/9913-order-details?code_type=7

내가 작성한 정답

Oracle, PostgreSQL, MySQL

select c.first_name, o.order_date, o.order_details, o.total_order_cost
from orders o
join customers c 
on o.cust_id = c.id and first_name in ('Jill', 'Eva')
order by c.id;