Structured Query Language
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 |
Write SQL commands for the following statements:
Sponsor Area
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 |
Write SQL commands for the following statements:
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:
Sponsor Area
Sponsor Area