Write SQL to rank top products per category

Suppose you are given a relational schema with two tables: products and order_items. The products table stores product master data: product_id (integer) — unique identifier for a product category (string) — name of the product category The order_items table stores one row per purchased item: order_id (integer) — identifier of the order product_id (integer) — product that was purchased quantity (integer) — number of units bought unit_price (decimal) — price per unit…