Customer First Order and Order Count

Write SQL to show each customer's first_order_date and total_orders.

customers(id, name), orders(id, customer_id, order_date)