Blog

Small text message

Powered by Blogger.

About Me

My Photo
Jesus Ventura
View my complete profile

Followers

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: