Question: 4. Write a query to display the customer code, last name, first name and sum of all invoice totals greater than $1,000. Sort by the

4. Write a query to display the customer code, last name,

4. Write a query to display the customer code, last name, first name and sum of all invoice totals greater than $1,000. Sort by the sum of invoice totals in descending order. Title the column of the sum of the invoice totals as Total Invoice and just display totals between $1,800 and $2,500.

5. Write a query to display the Product SKU, Product description and the Product Price as US currency (2 decimal points) sorted by Product Price. Label your column as SKU, Description and Price.

6. Write a query to display the last name, first name, title, department number for all employees who were hired during the calendar year of 2015. Sort the output by department number, last name, and first name.

7. Write a query to display the vender ID, name and Product SKU for ALL vendors, including those who do NOT provide us with products currently.

8. Write a query to display the vender ID and vender name for those vendors who do not currently supply us with products.

9. Write a query to display the employee number, last name, title, email and department name of each employee whose job title ends in the word ASSOCIATE (case insensitive). Sorted by department number and employee title.

10. Write a query to display the brand ID, brand name, brand type, and average price of product for the brand that has the largest average product price.

FIGURE P7.27 THE CHO7_LARGECO ERD LOCUSTOMER PK Custode CustFrame Cust Lname Cust Street Custy Cust State Cust ZIP Cust Balance LGBRAND PK Band.ID Brand Name Brand Type includes plapos LGINVOICE PK in Num appears on contains LGLINE PKFK1In Num PK Line Num FKZ Prod_SKU Line City Line Price + LGPRODUCT PK Prod SRL Prod Descript Prod Type Prod Base Prod Category Prod Price Prod QOH Prod Min FK1 Brand_10 FK Custcode Inv_Date Inv Total FK2 Employee_ID competes I provided by LGEMPLOYEE PK Em Num EmpFrame Emp_name Emp Emas Emp_Phone Emp Hiredate Emp_Title Emp_Comm FK1 Depl_Num Y has LGSALARY HISTORY PK.FK1 Emp Num PK Sal From Sal End Sal Amount LGSUPPLIES PK,FK1 Vend PK,FK2 ProslSKU prou des E empoys manges LGVENDOR PK Vend 10 LGDEPARTMENT PK Dest_Num Dept_Name Dept Mail Box Dept Phone FK1 Emp_Num Vend Name Vend_Street Vond City Vand State Vand ZIP

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!

Write a query to display the customer code, first name, last name, and sum of all invoice totals for customers with cumulative invoice totals greater than $1,500. Sort the output by the sum of...

Write a query to display the employee number, last name, first name, and sum of invoice totals for all employees who completed an invoice. Sort the output by employee last name and then by first...

Write a query to display the employee number, last name, first name, and sum of invoice totals for all employees who completed an invoice. Sort the output by employee last name and then by firstname....

LGCUSTOMER PK Cust Code Cust Frame Cust_Lname Cust Street Cust City Cust State PK FK1 Cust_ZIP Cust Balance places LGINVOICE Inv Num Cust Code Inv_Date Inv Total FK2 Employee ID completes LGEMPLOYEE...

Write a query to display the customer code, first name, and last name of all customers who have had at least one invoice completed by employee 83649 and at least one invoice completed by employee...

52. Write a query to display the customer code, first name, and last name of all customers who have had at least one invoice completed by employee 83649 and at least one invoice completed by employee...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql 30. Write a query to display the first name, last...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql OR...

SQL CODE: 30. Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title "CLERK I." Sort the output by...

Write a query to display the customer code, balance, and total purchases for each customer. Total purchase is calculated by summing the line subtotals for each customer. Create a query to produce the...

Find v(t) and i(t) in the circuit of Fig. 7.115. 20

Use the formula t=(In2)/(k) that gives the time for a population, with a growth rate k, to The growth model A=3e^(0.002t) describes the population, A, of a country in million?

Inflation risk deals with: changes in interest rates. political or social conditions. bad management and / or unsuccessful products. a reduction in purchasing power.

Exercise 13-7 Sheffield Hardware Company's payroll for November 2017 is summarized below. Amount Subject to Payroll Taxes Unemployment Tax Wages FICA Federal State Payroll Due $123,500 $123,500...

3. Messages of affect and value will decrease. Ambiguity in interpreting information will increase. Managers will have to seek new ways of communicating the affective component of messages.

6. Expectations of work performance may be machine driven. Employees in some organizations will perceive this as dehumanizing and coercive. (pp. 480481)

2. More informal messages and short-circuiting of the hierarchy will occur. Organization structure and formal information flow will be redefined.