Page 67 - IP

C_ID ClientName City P_ID
Dreamz
01 Disney New Delhi P002

05 Life Line Inc Mumbai P005
12 98.4 New Delhi P001

15 Appolo Banglore P003

Write the commands in SQL queries for the following:

(i) To display the details of Product whose Price is in the range of 40 and 120

(Both values included) 1

(ii) To display the ClientName, City from table Client and ProductName and
Price from table Product, with their corresponding matching P_ID

(iii) To increase the Price of all the Products by 20.

(c) In a Database School there are two tables Member and Division as
show below.

Table: Member
Empld Name Pay Divno

1001 Shankhya 34000 10

1003 Ridhima 32000 50

1002 Sunish 45000 20

Table :
Division

Divno Divname Location
10 Media TF02

20 Dance FF02

30 Production SF01

8