CBSE eBooks
CBSE Guess > eBooks > Class XII > Computer Science By . Mr. MRK
Chapter – 8 . STRUCTURED QUERY LANGUAGE
  
(vii) SELECT ClientName, ManufacturerName FROM Product, Client WHERE Client.Prod_Id=Product.P_Id;
Ans.
| Client Name |
Manufacturer
Name |
| Cosmetic Shop |
ABC |
| Total Health |
ABC |
| Live Life |
XYZ |
| PrettyWoman |
XYZ |
| Dreams |
LAK |
(viii) SELECT ProductName, Price * 4 FROM Product.
| ProductName |
Price*4 |
| Talcom Poweder |
160 |
| Face Wash |
180 |
| Bath Soap |
220 |
| Shampoo |
480 |
| Face Wash |
380 |
Outside Delhi 2008
5.b. Consider the following tables Item and Customer. Write SQL commands for the statement
(i) to (iv) and give outputs for SQL queries (v) to (viii)
| Table: ITEM |
| I_ID |
Item Name |
Manufacturer Price |
| PC01 |
Personal Computer |
ABC 35000 |
| LC05 |
Laptop |
ABC 55000 |
| PC03 |
Personal Computer |
XYZ 32000 |
| PC06 |
Personal Computer |
COMP37000 |
| LC03 |
Laptop |
PQR 57000 |
| Table: CUSTOMER |
| C_ID |
Customer Name |
City I_ID |
| 01 |
N.Roy |
Delhi LC03 |
| 06 |
H.Singh |
Mumbai PC03 |
| 12 |
R.Pandey |
DelhiPC06 |
| 15 |
C.Sharma |
DelhiLC03 |
| 16 |
K.Agarwal Banglore |
PC01 |
Computer Science By Mr. MRK
| 
