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