0% found this document useful (0 votes)
18 views16 pages

SQL Query for Chennai Orders Over 1000

Uploaded by

premkannanmscds
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
18 views16 pages

SQL Query for Chennai Orders Over 1000

Uploaded by

premkannanmscds
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

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'.

You might also like