Database: customers_and_orders
Question: Show all customer names, ids and the number of orders by 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