SQLQuokkaSQLQuokkaMeta Shops wants to promote brands with a real product range. The catalog can list the same product more than once (for example in different pack sizes), so a brand's product count is the number of distinct product names. A brand qualifies when it has at least 2 distinct products and the average price across all of its catalog rows is strictly greater than 3. Write an SQL query that returns brand, product_count and avg_price rounded to 2 decimal places. Order the results by brand ascending.
Loading…
Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.
Ask questions, share alternate queries, and explore solutions
Your recent query executions and answer checks
This will insert the verified MySQL solution into your editor so you can study how each clause transforms the table.