How many orders each customer have?
SELECT customer_id, count ( * )  from orders group by customer_id
count of orders for each customer refers to COUNT(*); grouping by customer refers to GROUP BY customer_id;