Select Query
select c.name from customer_t5 c JOIN order_t5 o on c.cust_no=o.client_no JOIN sales_order_t5 s ON o.order_no = s.sales_order_no JOIN product_t5 p ON s.product_no = p.prod_no where unit_price >=1000;Output
NAME ---------- pratik aman dilkhush Ajay