Problem:1
Problem : 2
Solve : Heuristics Query Optimization
Consider the following three tables:
Orders(order_id, customer_id, product_id, quantity)
Customers(customer_id, name, city)
Products(product_id, product_name, price)
Write an SQL query to retrieve the names of customers, product names,
and quantities for all orders where the price of the product is greater
than 1000 and the customer is from 'Chennai'.