ISQS 3348 Fall2022

Individual Assignment-5 (IA-5)

Manipulating, Summarizing, and Grouping Data

This is an individual assignment, and as such please submit your own work. Submit your answers as a Word file to the Blackboard course website by the due date. Use the following diagram and the sams_textbook database on the Blackboard course site. Questions 1 5 are required. The question 6 is a bonus question.

For each question, please capture a screenshot containing (1) your SQL query and (2) the corresponding result, and copy the screenshot to this word file below each question.

How many products do we stock? Label the field.

What was the date of the most recent order? Label the field.

What was the average total price of all items ordered? Label the field.

List the order numbers and total number of items from each order number. Ensure each field is labeled.

List the country and the number of vendors in each country. Sort the list by the number of vendors in each country, greatest first. Ensure each field is labeled.

List the vendors (by ID only) and the number of products they offer which come with an accessory/ accessories (listed as with in the product description). Sort the list by the number of products, greatest first. Ensure each field is labeled.