Datamart to Looking for the Profit Every Month - Edubirdie

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

2023
Views:

240

Pages:

2
Author:

Muthia M.

1. Make datamart to looking for the profit for every montj with datamart_latihan as ( select r.rental_id, rental_date, c.first_name, c.last_name , concat(c.first_name,' ',c.last_name) as full_name, return_date, p.amount 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 ), soal_1 as ( select extract(month from rental_date) as bulan, extract(year from rental_date) as tahun, sum(amount) from datamart_latihan group by 1,2 ), soal_2 as ( select full_name, count(rental_id) as jumlah_peminjaman from datamart_latihan group by 1 ) select * from soal_2 order by 2 desc

Related Documents

Datamart to Looking for the Profit Every Month

Datamart to Looking for the Profit Every Month - Page 1

Datamart to Looking for the Profit Every Month - Page 2

of 2

Recommended Documents

ITS Databases Practice Exam 25

ITS Databases Practice Exam 25

American Baptist College CSCI 1534 | Data Analysis and Visualization

Assignment

New Documents from this Course

Input and Output Operation in Python

Input and Output Operation in Python

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Python Data Operator (Assignment Operators and Comparison Operators)

Python Data Operator (Assignment Operators and Comparison Operators)

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Operations using Data Types and Operators in Python

Operations using Data Types and Operators in Python

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Intersect, Distinct, Alias, Computed Column and Sort

Intersect, Distinct, Alias, Computed Column and Sort

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Flow Control with Iteration (While Statement and For Statement)

Flow Control with Iteration (While Statement and For Statement)

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Flow Control with Desicions

Flow Control with Desicions

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Aggregate in Database

Aggregate in Database

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note

Data Protection Measures

Data Protection Measures

American Baptist College CSCI 1534 | Data Analysis and Visualization

Lecture Note