Question
Consider the following tables CARDEN and CUSTOMER and answer (b) and (c) parts of question:
TABLE: CARDEN
|
Ccode |
CarName |
Make |
Color |
Capacity |
Charges |
|
501 |
A-Star |
Suzuki |
RED |
3 |
14 |
|
503 |
Indigo |
Tata |
SILVER |
3 |
12 |
|
502 |
Innova |
Toyota |
WHITE |
7 |
15 |
|
509 |
SX4 |
Suzuki |
SILVER |
4 |
14 |
TABLE: CUSTOMER
|
CCode |
Cname |
Ccode |
|
1001 |
Hemant Sahu |
501 |
|
1002 |
Raj Lal |
509 |
|
1002 |
Feroza Shah |
503 |
|
1004 |
Ketan Dhal |
502 |
Give the output of the following SQL queries:
- SELECT COUNT(DISTINCT Make) FROM CARDEN;
- SELECT MAX(Charges),MIN(Charges) FROM CARDEN;
- SELECT COUNT(*),Make FROM CARDEN;
- SELECT CarName FROM CARDEN WHERE Capacity=4;
Solution
| (i) |
COUNT(DISTINCT Make) |
| (ii) |
MAX(Charges) MIN(Charges) |
| (iii) |
COUNT(*) Make |
| (iv) |
CarName SX4 |
