SQL for Data Analytics · HAVING

HAVING

HAVING5 min

HAVING5 min

Run queries here while you watch. When I tell you in the video to open Workbench and try something, use this box. This is for your own practice. It isn't recorded or part of your unit submission.
⌘/Ctrl + Enter
Try it
Write a query that shows the countries with more than five customers. Show the country and the count.
⌘/Ctrl + Enter
Write a query that shows the average price of the products in each category, but only for categories where the average is 25 or more. Order the results from highest to lowest average. Show the category ID and the average.
⌘/Ctrl + Enter