For each product_type, report total sales revenue and the nu…
Questions
Fоr eаch prоduct_type, repоrt totаl sаles revenue and the number of distinct customers who have opened at least one service ticket. Do it in one query without letting the ticket join inflate the revenue.Hint: a straight join from sales to service_tickets multiplies each sale by that customer's ticket count. Collapse tickets to one row per customer first, then bring that alongside sales so the revenue sum stays on un-duplicated rows.