-
Notifications
You must be signed in to change notification settings - Fork 8
/
Copy pathsqlquery12.sql
51 lines (46 loc) · 1.56 KB
/
sqlquery12.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
Problem Statement:
Write a SQL query for the red-colored products whose original weight is less than 10 units;
displaying information in the output table as: product name, colour and 20 times the original weight as 'w'.
Information about the table:
Table Product:
+------+----------+--------+--------+
| Pno | Pname | Colour | Weight |
+------+----------+--------+--------+
| 1 | pen | red | 5 |
| 2 | pencil | rlue | 10 |
| 3 | sharpner | red | 3 |
| 4 | eraser | white | 6 |
| 5 | stapler | green | 40 |
| 6 | whitener | white | 15 |
+------+----------+--------+--------+
Table Supplier:
+------+----------+------------+--------+
| Sno | Sname | City | Status |
+------+----------+------------+--------+
| 1 | rachit | jalandhar | active |
| 2 | sahil | amritsar | active |
| 3 | anjali | bareilly | active |
| 4 | priyanka | delhi | active |
| 5 | krishna | jaipur | active |
| 6 | kashish | chandigarh | active |
+------+----------+------------+--------+
Table SP:
+------+------+------+
| Sno | Pno | Qty |
+------+------+------+
| 1 | 6 | 10 |
| 2 | 4 | 8 |
| 3 | 3 | 15 |
| 4 | 5 | 6 |
| 5 | 1 | 11 |
| 6 | 2 | 20 |
+------+------+------+
Solution:
select pname, colour, 20*weight as w from product where colour='red' and weight <10;
Output:
+----------+--------+------+
| pname | colour | w |
+----------+--------+------+
| pen | red | 100 |
| sharpner | red | 60 |
+----------+--------+------+