EssayNICE | 24/7 Homework Help

Essaynice Will Help You Write Your Essays and Term Papers

Answered » You can buy a ready-made answer or pick a professional tutor to order an original one.

Answer all Questions on the spaces provided. For all the questions below, provide the code and output. The screenshots MUST include the date/time on your computer/laptop for it to be graded. This assi

by | Sep 9, 2023 | computerscience

Answer all Questions on the spaces provided. For all the questions below, provide the code and output. The screenshots MUST include the date/time on your computer/laptop for it to be graded. This assignment should be individual work. Once completed, save the file as a PDF, and submit.

As a new intern working in a small music company, you have been asked to look into the database and generate monthly reports of items sold in the store. Copy and run the code provided to create the tables for the database. Write simple SQL queries that will display output according to the requirements below.

Note: For the script provided: run each table script individually, NOT the entire script at once.

1.     Display an output of customer details. The output fields should be displayed in order and exactly as shown here (with the spaces): Last Name, First Name, City, and Phone #. 

2.     Display an output of the order details. The output fields should be displayed in order and exactly as: Order ID, Quantity Ordered, Order Date, and Date Shipped. 

3.     Display an output of the customers and order details. The output fields should be displayed in order and exactly as: Last Name, First Name, Item ID, Title of Song, Artist, Quantity, and Unit Price. The list should be ordered in descending order based on last name. 

4.     Given the output from above, use your statistical skills to calculate the average, median, and mode of the unit price. Show your work. 

  

HOME TO CERTIFIED WRITERS

Why Place An Order With Us?

  • Certified Editors
  • 24/7 Customer Support
  • Profesional Research
  • Easy to Use System Interface
  • Student Friendly Pricing

Have a similar question?

PLAGIRAISM FREE PAPERS

All papers we provide are well-researched, properly formatted and cited.

TOP QUALITY

All papers we provide are well-researched, properly formatted and cited.

HIGHLY SECURED

All papers we provide are well-researched, properly formatted and cited.

Open chat
1
Powered by essaynice
Hello! Welcome to to our whatapp support.
We offer READY solutions, HIGH QUALITY PLAGIARISM FREE essays and term-papers.

We are online and ready to help