List in alphabetical order of names of customers with more than $10 million in annual revenue Give names and average monthly revenue of customers having annual revenue exceeding $20 million. Name the column Average_Monthly_Revenue with a literal (note the underscores). (Hint: Use division.)
What are the truck ID’s of trucks that have carried small shipments. Small shipments are defined as those that weigh less than 800 pounds? (HInt: Avoid duplcates.)
Give names of all customers whose type is not retailer or wholesaler and who have over $20 million in annual revenue. Use the NOT IN keywords.
To what cities have customers with revenue less than $5 million sent shipments? (Hint: Avoid duplicates.)
For each customer (cust_id and cust_name) with annual revenue under $10 million, and whose shipments average more than 5000 pounds, what is the total weight of shipments they’ve sent? Label the total column as Total_Weight. (Hint: Requires Having.)
What is the total weight of shipments that the Mack trucks have carried? (Truck make is 'Mack'.) Label the answer column as Total_Loads.