Find the customer id of Savannah?
select customer_id from customers where customer_name = "Savannah"
Which date of order placed in Alberto?
select t2.date_order_placed from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id where t1.customer_name = "Alberto"
What are the customer details of order id 2?
select customer_details from customers where customer_id = "2"
Find the details of all distinct customers who have orders with status "On Road".
select distinct t1.customer_details from customers as t1 join orders as t2 on t1.customer_id = t2.customer_id where t2.order_status = "On Road"