Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

According to Sakila database: a) Write an Sql sentence that gives Total Amount of payment for each staff b) Write an sql sentence that gives

image text in transcribed

According to Sakila database:

a) Write an Sql sentence that gives Total Amount of payment for each staff

b) Write an sql sentence that gives only number of payment_id from payment table that matches with rental table. Write your sql sentences using left and right join operands. Is there any difference between left and right join queries? If so, define the reason.

c) Write an sql sentence that gives customer names and their -individual- total payment amount.

d) Write an sql sentence that gives countries and total customers from that countries.

CUSTOMERID NUMBER(22) FK 0 NVENTORY ID NUMBER(22) PK INVENTORY ID NUMBER(22) FK RETURN_DATE TIMESTAMP N CUSTOMER ID NUMBER(22) PK ADDRESS ID NUMBER(22) FK REPLACEMENT_COST NUMBER(5,2) CATEGORY ID NUMBER(22) PK FK POSTAL_CODE VARCHAR2(10) N 2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

The company has fair promotion/advancement policies.

Answered: 1 week ago