Hi ! Studying late night...
02:18 am

Sponsor Area

Sponsor Area

Question is

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:

  1. To display the names of all the silver colored
  2. To display name of car, make and capacity of cars in descending order of their sitting
  3. To display the highest charges at which a vehicle can be hired from
  4. To display the customer name and the corresponding name of the cars hired by them

Mock Test Series

Sponsor Area

Sponsor Area

NCERT Book Store

NCERT Sample Papers

Entrance Exams Preparation