Structured Query Language

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:

  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;

Answer

(i)

COUNT(DISTINCT Make)
4

(ii)

MAX(Charges)         MIN(Charges)
 35                          12

(iii)

COUNT(*) Make
5              Suzuki

(iv)

CarName SX4
C        Class

Sponsor Area