Make the following Quires Select Those Product whose price is greater than 1000 and less than 2000 Select Those shop whose city is Hyderabad and islambad. Select all products whose name end with r....

 Make the following Quires

1. Select Those Product whose price is greater than 1000 and less than 2000


2. Select Those shop whose city is Hyderabad and islambad.

• Select all products whose name end with r.

1. Select all customers whose name contain i (start,end,or middle,anywhere)


2. Select All the products of Kiran Electronics.


3. Count All Products that in Computer Category

• Count All Products That is from Junaid Communication.


• Count All Products That is Purchased by Rehan

1. Select All Products That is purchased by Sajid


2. Select All Products That is in Mobile Accessory Category


3. Select All Products whose shop in Hyderabad.

• Select Customers That purchase product from Zeeshan computers


• Select All Products whose category is Computer and mobile


• Count Products with Their Category

Eg,,      Category          Total Products

                                    Mobile                          5

                                    Computer                     8

                                    ETC….