WIL 23-08-06

level·2023년 8월 6일

TIL

목록 보기
70/95

sql특강2회차

-- left join : null 포함
-- group by <?>
-- having num_orders=0

-- create or replace view total_spent_view as select first_name, sum(amount) as total_spent from customers
-- join orders on customers.id=orders.customer_id
-- group by first_name;

-- select first_name, total_spent from total_spent_view
-- where total_spent = (select max(total_spent) from total_spent_view)


ChatGPT를 이용하여 프론트 만들기 특강

https://www.youtube.com/watch?v=X1u7R9VlNmc&list=PLkwJpYlJXL7H9V4P4B1l0xkbjRDNAB3l9&index=1

0개의 댓글