Question

Consider the following table Doctor and answer the Query in MYSQL:

ID

Department

OPD_DAYS

Doctor_Name

Fee

H101

ENT

MON

Keshav

400

H102

Oncology

TUE

Dharma

600

H103

ENT

WED

Kavita

400

H104

Gynecology

THRUS

Poonam

450

H105

Haematology

MON

Dinesh

600



Display department of all doctors whose name starts with "K".

Answer 1

Answer:

Kavita

Explanation:

KeshavKeshav 400. H102 Oncology TUE Dharma 600. H103 ENT WED Kavita 400. H104 Gynecology THRUS Poonam 450