SQL · Amazon · Easy
Description The products table holds the catalog of items: product_id is the primary key. The product_sales table records sales performance: product_id is the primary key. rating can be any value from 1.0 to 5.0. For each product category, identify the product that generated the highest sales_quantity. If two or more products tie on sales quantity, the one with the larger rating is chosen. Return the category_name and product_name of that winning product, sorted…
Checking your access…