Show all the customer information.
select * from customers
How many orders did each customer make?
select count(*) from customer_orders group by customer_id
Which customer made the largest number of orders?
select * from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id group by t2.customer_id order by count(*) desc limit 1
What are the name, phone number and email address of this customer?
select t1.customer_name, t1.customer_phone, t1.customer_email from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id group by t2.customer_id order by count(*) desc limit 1