using views on postgresql

PHOTO EMBED

Sun Apr 24 2022 02:28:00 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

create view penjualan_kentucky_california as
select state,sales
from orders_tab as ot 
where lower(state) ~ 'kentucky|california';

select sum(sales)
from penjualan_kentucky_california
content_copyCOPY