SQL-Aggregate Functions-1251 Average Selling Price
The problem requires calculating the average selling price for each product, where the average selling price equals the total revenue divided by the quantity sold. Solution approach: We need to compute the total revenue and total quantity for each product. The total quantity can be obtained using th...