How many orders are priced higher than 1000?
select count ( * ) from customer_orders as t1 join order_items as t2 on t1.order_id = t2.order_id join products as t3 on t2.product_id = t3.product_id where t3.product_price > 1000
What are the order dates of orders with a price higher than 1000?
select t1.order_date from customer_orders as t1 join order_items as t2 on t1.order_id = t2.order_id join products as t3 on t2.product_id = t3.product_id where t3.product_price > 1000
What are their planned delivery dates?
select t1.planned_delivery_date from customer_orders as t1 join order_items as t2 on t1.order_id = t2.order_id join products as t3 on t2.product_id = t3.product_id where t3.product_price > 1000
And what were the actual delivery dates?
select t1.actual_delivery_date from customer_orders as t1 join order_items as t2 on t1.order_id = t2.order_id join products as t3 on t2.product_id = t3.product_id where t3.product_price > 1000