Question: 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

According to Sakila database: a) Write an Sql sentence that gives

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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...

Goals Explore triggers and stored procedures within a database, see how they work and how they are engaged. Create your own and see what happens. Instructions Use the same database as Lab 2 (see Lab...

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

The following questions will help you to practice writing SQL statements. The questions are based on the "sakila" database schema on MySQL Workbench. 1. Write the sql statement that will provide you...

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

ISFM-300 Case Study, Stage 2: Business Process Analysis and Functional Requirements Before you begin this assignment, be sure you: 1. Have completed all previously assigned readings, particularly...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

True or False: 1. The government can use fiscal policy to stimulate the economy out of a recession or to try to bring inflation under control. 2. When tax revenues are greater than government...

Plush Pals Inc. manufactures toy stuffed animals. The direct labor time required to cut, sew, and stuff a toy is 8 minutes per unit. The company makes two types of stuffed toysa lion and a bear. The...

3. What are avoidable costs?

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

The company has fair promotion/advancement policies.

Refer to the Lets Talk Business feature that opens this chapter. Decide whether each of the proposals discussed there would be internal or external, unsolicited or solicited, and formal or informal....

How does the Attention/Interest/Desire/Action plan (described in Chapter 9) for writing a persuasive message apply to writing an unsolicited internal proposal? (Objectives 1 and 3)