ComputerScienceExpert

(7)

$18/per page/

About ComputerScienceExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Applied Sciences,Calculus See all
Applied Sciences,Calculus,Chemistry,Computer Science,Environmental science,Information Systems,Science Hide all
Teaching Since: Apr 2017
Last Sign in: 1 Day Ago
Questions Answered: 4836
Tutorials Posted: 4834

Education

  • MBA IT, Mater in Science and Technology
    Devry
    Jul-1996 - Jul-2000

Experience

  • Professor
    Devry University
    Mar-2010 - Oct-2016

Category > Programming Posted 23 May 2017 My Price 9.00

Write a query to determine the total number

I need help completing one of my numerals assignments from devry university.

the class I'm taking is cis336. I need help with lab 6.

below is an attachment to all 15 questions.

 

1.             Write a query to determine the total number of items on each order.  Display the order_id and the total with a heading of TotalItems (note no spaces).  Filter to only display information for order_id of 600 or higher.

 

2.             Re-do query 1 but filter to only show those orders with more than 2 items ordered.  Sort by the number of items ordered, lowest to highest.

 

3.             The order_details table has a quantity for each item ordered.  Show the total amount charged for each item on the order (quantity times price).  Display order_id, the item id, the unit price, the quantity times price of the item labeled as “Itemtotal” (note NO spaces).  Sort by order id and filter to only display those order ids between 400 and 700.

 

4.             Write a query to display the total amount for each order:  show the order id and total.  Sort by descending order on the total and only display orders with a total of $40 or more.

 

5.             Re-do query 4 but show the customer name for each order (formatted as a single field with heading of Customer) along with the city, order id and total.  Filter to only display customers that live in California.  Sort by city.

 

6.             Display the total amount of sales per item.  Show title, total quantity sold with a heading of Quantity, total sales with a heading of “TotalSales” (not NO space).  Sort by highest to lowest total.

 

7.             Display the total sales for each customer:  show customer name (as single field) with a heading of Cutomer and total.  Sort lowest to highest total.  Filter to only display customers with $50 or more in total orders.

 

8.             Use subqueries to determine which (artist) had the item ordered in highest quantity on an order?  First determine the highest quantity on any order, then determine the item number associated with it, then display the artist.

 

9.             Display the total sales by artist:  show artist name, total.  Sort highest to lowest.

 

10.         USE A SUBQUERY to Increase price of all items by ‘No Rest for the Weary’ by 10%.  If working in MySQl you will need to disable safe mode.  Show prices before and after.  Rollback after.

 

11.         USE A SUBQUERY to display  names of customers that have unshipped orders.

 

12.         Display the total amount of sales made  to customers in NY  

 

13.         USE A SUBQUERY to list the items (title and artist) of items that have never been ordered

 

14.         Show the order history for Samuel Jacobsen.  Display the order id, order date, ship date, and total.

 

15.         Show the total amount of sales per sales rep.  Display the employee name as a single field along with the total sales, sorted by highest to lowest sales.

 

This is the end of Lab 6.

Answers

(7)
Status NEW Posted 23 May 2017 02:05 AM My Price 9.00

-----------

Attachments

file 1495506835-Solutions file 2.docx preview (51 words )
H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------
Not Rated(0)