Please write SQL queries to solve the following tasks:
-
Retrieve all customers from the “Customers” table whose names start with the letter ‘A’.
-
Calculate the total revenue generated by each customer from the “Orders” table, and order the results in descending order.
-
Find the average order quantity for each product from the “OrderDetails” table, and return the results along with the product name.
-
Identify the top 5 products with the highest unit price from the “Products” table, and return the results.