Question

Consider the table Patient given below and write SQL commands.

Table: Patient
Patientid	Name	City	Phone	Dateofadm	Department
1000001	Ritvik Garg	Delhi	68476213	2021-12-10	Surgery
1000002	Rahil Arora	Mumbai	36546321	2022-01-08	Medicine
1000003	Mehak Bhatt	Delhi	68421879	2022-02-02	Cardiology
1000004	Soumik Rao	Delhi	26543266	2022-01-11	Medicine
1000005	Suresh Sood	Bangalore	65432442	2021-03-09	Surgery

1. Display the details of all patients who were admitted in January.
2. Count the total number of patients from Delhi.
3. Display the last 2 digits of the Patient id of all patients from Surgery Department.

Answer 1

1. Select* from patient where month name (date of adm) = 'January';
2. Select count(*) from patient where city = 'delhi';
3. Select right(patient id,2) from patient where department = 'surgery';