Write a query using the count function with the GROUP BY clause to return the number orders for each order’s status code example
Example: sql groub by count
SELECT COUNT(Id), Country
FROM Customer
GROUP BY Country
SELECT COUNT(Id), Country
FROM Customer
GROUP BY Country