Good Evening
22:45 pm

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

Give the output of the following SQL queries:

  1. SELECT COUNT(DISTINCT Make) FROM CARDEN;
  2. SELECT MAX(Charges),MIN(Charges) FROM CARDEN;
  3. SELECT COUNT(*),Make FROM CARDEN;
  4. SELECT CarName FROM CARDEN WHERE Capacity=4;

Mock Test Series

Sponsor Area

Sponsor Area

NCERT Book Store

NCERT Sample Papers

Entrance Exams Preparation