Database: customers_and_orders
Question: What are the names, ids, and number of orders made for each customer?
SQL:
SELECT T2.customer_name ,  T1.customer_id ,  count(*) FROM Customer_orders AS T1 JOIN Customers AS T2 ON T1.customer_id  =  T2.customer_id GROUP BY T1.customer_id