News

AVG(s.sales) OVER (PARTITION BY c.segment) AS avg_sales_by_segment, ROW_NUMBER() OVER (PARTITION BY c.segment ORDER BY s.sales DESC) AS row_number ...