IT244- IT403 Database
Session#3
1. Using the table (students) provided in the next page, provide SQL queries that retrieve
the following:
a. Students.ames and genders
b. Names of female students
c. Students who study nursing
d. Students whose name start with the letter M
e. Students in an ascending order by their names
f. Students in a descending order by their ids
g. Students whose ids are greater than 3
h. Colleges with eliminating duplicates (hint: use distinct keyword, result should
include four colleges)
i.
all the data in the created table (students).
2. Update the created table (students):
a. Insert the following values in the students table
id
8
1
name
Talal
Ahmed
gender
Male
Male
2
3
Muhammad
Maha
Male
Female
collage
Science
Computer
Science
Science
Engineering
IT244- IT403 Database
Session#3
b. Modify Talalàcollege to nursing instead of science.
c. Delete Talalàinformation from the table.
IT244- IT403 Database
Session#3
create table students (
id integer,
name varchar (20),
gender varchar (6),
college varchar (50),
primary key (id)
);

Purchase answer to see full
attachment