There is a table T with order ids (oi) and customer ids (ci). Each order only belongs to a single customer and each customer may have multiple orders. How do you find how many orders each customer has? Please provide the SQL.
select count oi.orders ids
from table 'T'
where , ci.customer ids = , oi.irder ids