What was the product id for the customer that ordered the most product quantity?
select t1.customer_id from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id join order_items as t3 on t3.order_id = t2.order_id group by t1.customer_id order by sum ( t3.order_quantity ) desc limit 1
What are the name and phone of the customer with the most ordered product quantity?
select t1.customer_name, t1.customer_phone from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id join order_items as t3 on t3.order_id = t2.order_id group by t1.customer_id order by sum ( t3.order_quantity ) desc limit 1
What is the address for the customer Cleo?
select customer_address from customers where customer_name = "Cleo"
What is the email for Customer name of Cleo with phone number 1-202-928-5395?
select customer_email from customers where customer_name = "Cleo" and customer_phone = "1-202-928-5395"
What is the customer number for customer name Cleo?
select customer_number from customers where customer_name = "Cleo"