What was the amount of orders for the customer that had that most orders?
SELECT count ( * )  FROM customers AS T1 JOIN orders AS T2 ON T1.customer_id   =   T2.customer_id GROUP BY T1.customer_id ORDER BY count ( * )  DESC LIMIT 1
amount of orders for the customer that had the most orders refers to MAX(COUNT(order_id));