Page 76 - 2611_SmartGPT Pro V(5.0) C-8

21 st #Critical Thinking
LAB ACTIVITY Century #Technology Literacy
Skills

Consider the following PLAYERS table:
Table: PLAYERS

Player_ID Name Sport Country Age

S001 Virat Cricket India 35
S002 Ronaldo Football Portugal 39

S003 Sindhu Badminton India 28
S004 Messi Football Argentina 37
S005 Mary Boxing India 41

Now, write SQL commands for the following:
(a) Create a PLAYERS table under the Sports database.
(b) Display details of all the Indian players.
(c) Show the names of all the football players.

(d) Change the country of player “Ronaldo” to “Brazil”.
Consider the following PATIENTS table:

Table: PATIENTS

Player_ID Name Sport Country Age

P001 Rahul 20 Fever Dr. Sinha
P002 Maya 34 Diabetes Dr. Ahmed
P003 Aman 27 Flu Dr. Sinha
P004 Riya 15 Asthma Dr. Gupta
P005 John 40 Diabetes Dr. Ahmed

Now, write SQL commands for the following:
(a) Create a PATIENTS table under the Hospital database.
(b) Insert a new patient “Priya”, age 25, Flu, doctor Dr. Sinha, Patient_ID P006.

(c) Show names of all patients suffering from Diabetes.
(d) List all details of patients being treated by Dr. Sinha.
(e) Update the age of patient “Rahul” to 21.

74 Computer Science (V5.0)-VIII