SQL Quiz # 1
Thursday, September 15, 2011 - - 0 Comments
StudentID | Fname | MI | Lname | Gender | YearLevel | SecName |
| | | | | | |
1 | Ely | B | Buendia | M | 1 | A |
2 | Bab | C | Lamoun | M | 2 | B |
3 | Jolen | C | Lamoun | F | 1 | A |
4 | Dagul | S | Sungcal | M | 2 | A |
5 | Barbie | L | Sabaybunot | F | 1 | B |
6 | Tiny | S | Sungcal | F | 3 | C |
7 | Brosia | M | Tangara | F | 3 | D |
8 | Paltik | L | Sabaybunot | M | 2 | D |
9 | Utoy | S | Sungcal | M | 4 | A |
10 | Noli | M | Tangere | M | 3 | C |
11 | Mao | D | Tsetung | M | 1 | D |
12 | Tomas | L | Sabaybunot | M | 4 | D |
13 | Pao | D | Tsetung | F | 3 | C |
14 | Sonia | C | Blade | F | 2 | A |
15 | Polgas | L | Cotto | M | 4 | A |
Create the following queries:
a. Query1 – for all students’ last name
b. Query2 – for all students in descending record by their StudentID
c. Query3 – for all female students
d. Query4 – for all male students
e. Query5 – for all female students in second year level
f. Query6 – for all male students in first and third year level
g. Query7 – for all students whose last name starts with letter S
h. Query8 – for all students in sections 1A and 4A
i. Query9 – for all students in sections 2B and 3C
j. Query10 – for all students in sections 4D and 1C
k. Query11 – for all students in section A only
l. Query12 – number of students’ records in the list
m. Query13 – all unique sections
This entry was posted on 4:17 PM
You can follow any responses to this entry through
the RSS 2.0 feed.
You can leave a response,
or trackback from your own site.
0 comments:
Post a Comment