show the name of the customer who has the most orders
SELECT T1.customer_name FROM customers AS T1 JOIN customer_orders AS T2 ON T1.customer_id   =   T2.customer_id GROUP BY T1.customer_id ORDER BY count ( * )  DESC LIMIT 1
name of the customer who has the most orders refers to MAX(count(*)) on a join between customers and customer_orders tables;