Question: Given the schema below write the SQL to answer the following questions. Each query should include at least one join. Table_Name : Column(s) customers :

Given the schema below write the SQL to answer the following questions. Each query should include at least one join.

Table_Name: Column(s)

customers: CustomerNumber, CustomerName, ContactLastName, ContactFirstName, phone, addressLines1, addressLines2, city, state, postalCode, Country, SalesRepEmployeeNumber.

employees: EmployeeNumber, LastName, FirstName, Extension, Email, OfficeCode, reportsTo, JobTitle.

offices: officeCode, City, phone, addressLine1, addressLine2, State, Country, postalCode, territory.

orderdetails: orderNumber, productCode, quantityOrdered, priceEach, OrderLineNumber.

orders: orderNumber, orderDate, requiredDate, ShippedDate, Status, Comments, CustomerNumber.

payments: CustomerNumber, CheckNumber, PaymentDate Amount.

productlines: productLine, TextDescription, htmlDescription, Image.

products: ProductCode, ProductName, ProductLine, ProductScale, ProductVender, productDescription, quantityInStock, BuyPrice, MSRP.

1. What Dates did Customers from postalCode 51003 make Payments?

2.What are the employeeNumbers for the employees that have the jobTitle of Sales Rep and work in Tokyo?

3. How many products were not ordered?

4.Who reports to a Sales Rep?

5.What is the total quantityOrdered for products ordered on 2004-01-29 for the productLine Vintage Cars?

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!

Introduction to databases FALL 20 Assignment III Based on the database schema that was used in assignment I, answer the following questions: 1. Write the business rules that are reflected by the...

This policy will be reviewed no later than 5 years of its authorisation date. At this point it will need to be re-authorised by the relevant authority at Xxz Financial Services Version Published...

Introduction to databases Assignment 1 Description of the schema The following database is used by a building materials company to edit invoices for its customers and to manage its inventory The...

Developments in Technology Light is incident from air on the end face of a multimode optical fibre at angle of incidence as shown below. n n 1 2 The refractive indices of the core and cladding are...

The question is for introduction to database system with sql live. The assignmemt is due on tomorrow 12p.m. Part 1 Maintaining and redesigning an existing database Create the following schema for...

SQL -- Classic Models Database NetBeans: Select the latest version of NetBeans and start it. Open the Services window (available from the window menu in NetBeans) Right-click Java DB and start the...

Please get the answers for the bolded question only given at the last Maintaining and redesigning an existing database Create the following schema for maintaining the books issued to the patrons....

You should write queries to answer the following questions. Use ' AS ' to change the column name where appropriate. Unless otherwise specified, you should use SUB - QUERIES and the quantifiers SOME,...

Background on SQL Server: Microsoft SQL Server is a popular enterprise-class DBMS that has been around for many years. SQL Server really handles SQL well, better than simpler tools such as Microsoft...

On September 17, 2013, Ziltech, Inc. entered into an agreement to sell one of its divisions that qualifies as a component of the entity according to generally accepted accounting principles. By...

Use the node-voltage method to find how much power the current source extracts from the circuit (Figure 1) if i = 1.1A and v = 53V. Express your answer with the appropriate units. 1 50 4 +1 V

In the private-label operating benchmarks section on p. 7 of each issue of the FIR, the industry-low, industry-average, and industry-high benchmarks for the margins over direct costs (as explained in...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

3. What value would it be to know that you were going to be training a class of persons between the ages of 20 and 35? Would it influence the approach you would take? How?

5. How do instructional objectives help learning to occur?

4. Help trainees set challenging mastery or learning goals.