SQL for Data Analytics · GROUP BY

GROUP BY

GROUP BY13 min

GROUP BY13 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 number of products in each category. Show the category ID and the count.
⌘/Ctrl + Enter
Write a query that shows the number of orders each employee has handled, busiest first. Show the employee ID and the count.
⌘/Ctrl + Enter