<prompt> Kujenga query kupata idadi ya maagizo kwa wateja ID.  <response>: Here is the SQL query to retrieve the count of orders by customer id:SQLSELECT customer_id, COUNT AS order_countFROM ordersGROUP BY customer_idORDER BY order_count DESC; 