Kizspy.me
[1 mark] Write a query to retrieve students' information in the "Computer Science"
department. The result should include: StudentID, StudentLastName, StudentFirstName,
and DepartmentName.
StudentID
StudentLastName StudentFirstName DepartmentName
8
9
-234567% 12 23
2
Tran
Binh
Computer Science
5
Hoang
Em
Computer Science
8
Bui
Hung
Computer Science
16
Mac
Son
Computer Science
26
Tao
Phuc
Computer Science
32
Luu
Vinh
Computer Science
35
Thanh
An
Computer Science
38
Chau
Diep
Computer Science
40
Tuan
Kiet
Computer Science
10
41
Van
Lan
Computer Science
11 47
Dao
Rang
Computer Science
12 53
Tan
Yen
Computer Science
13 59
Bao
Kiet
Computer Science
Picture 2.1
Question 3:
[1 mark] Write a query to retrieve students' information whose names start with the letter "T".
The result should include: StudentID, StudentLastName, and StudentFirstName. The results
should be sorted in ascending order by StudentLastName.
Zoom
+ 93%
Close
