Question: 5. Write a SQL query that displays the average of the OrderTotal column from the retail_order table. Use a column alias of AverageOrderAmount for the

5. Write a SQL query that displays the average of the OrderTotal column from the retail_order table. Use a column alias of AverageOrderAmount for the aggregate column. 6. Write a SQL query that displays the min and max of the OrderTotal column in the retail_order table. Use a column alias of SmallestOrderAmount for the min and LargestOrderAmount for the max. Use the vrg database for question 7. 7. Write a SQL query that displays the TransactionID column and the difference between the Sales Price and Acquistion Price columns from the trans table. Use a column alias of ProfitAmount for the calculated column. Remove rows where the difference between the Sales Price and Acquisition Price is NULL
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
