What is the total quantity ordered by each customer?
select sum(t3.order_quantity) from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id join order_items as t3 on t2.order_id = t3.order_id group by t1.customer_name
Return the customer who ordered the least quantity in total.
select * from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id join order_items as t3 on t2.order_id = t3.order_id group by t1.customer_name order by sum(t3.order_quantity) limit 1
What is that customer's payment method?
select t1.payment_method from customers as t1 join customer_orders as t2 on t1.customer_id = t2.customer_id join order_items as t3 on t2.order_id = t3.order_id group by t1.customer_name order by sum(t3.order_quantity) limit 1