SQL Count Function By Column
sql, sql-server, t-sql
Solution
You need it with a `group by`:
SELECT CusId, COUNT(CusID) AS NumOfOrders
FROM Orders
group by CusId
order by CusId;
Problem
``` CusID Order 3001 Hotdog 3001 Sausage 3002 Sausage 3003 Burger 3003 Hotdog 3002 Hotdog 3001 Burger ``` How I will use this count function? ``` SELECT COUNT(CusID) AS NumOfOrders FROM Orders ``` Desired output ``` CusID NumOfOrders 3001 3 3002 2 3003 2 ```