A05m2Traders - Coursework assignments PDF

Preview

Summary

Coursework assignments...

Description

Using the Revenue, and Shipments By Vendor and Year queries you created and modified, answer the following questions:

1) How much is the largest net gain the company had in a single transaction (note: answer will be rounded)?

2) How much is the largest net loss the company had in a single transaction (note: answer will be rounded)?

3) What company was the least commonly used shipping vendor in 2020 (in terms of total paid in shipping fees)?

4) What company had the largest individual shipping charge in 2019? What was the amount?

5) What company had the highest average individual shipping charge in 2018?

6) The Shipments By Vendor and Year query you created shows the overall total, minimum, and maximum for the shipments at the bottom of the query. Why is the overall average missing?...