University:
American Baptist College
Course:
CSCI 1534 | Data Analysis and Visualization
Academic year:

2023
Views:

226

Pages:

2
Author:

Muthia M.

1. Make SQL to show monthly sales for each category and language of rented films with datamart_latihan as ( select r.rental_id, c2.name as kategori, l.name as bahasa, rental_date, return_date, p.payment_date, p.amount as total from rental r left join customer c on c.customer_id = r.customer_id left join payment p on p.rental_id = r.rental_id left join inventory i on i.inventory_id = r.inventory_id left join film f on f.film_id = i.film_id left join language l on f.language_id = l.language_id left join film_category fc on fc.film_id = f.film_id left join category c2 on c2.category_id = fc.category_id ), soal_3 as ( select extract(month from rental_date) as bulan, extract(year from rental_date) as tahun, kategori, bahasa, sum(total) as pendapatan from datamart_latihan group by 1,2,3,4 order by 2,1 asc ) select * from soal_3 where pendapatan is not null