SQL for Data Analytics · HAVING
HAVING
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
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