Question

Consider the following tables SCHOOL and ADMIN and answer this question :

Write SQL statements for the following:

1. To display TEACHERNAME, PERIODS of all teachers whose periods are more than 25.

2. To display all the information from the table SCHOOL in descending order of experience.

3. To display DESIGNATION without duplicate entries from the table ADMIN.

4. To display TEACHERNAME, CODE and corresponding DESIGNATION from tables SCHOOL and ADMIN of Male teachers.

Answer 1

1. SELECT TEACHERNAME, PERIODS FROM SCHOOL WHERE PERIODS>25:

2. SELECT * FROM SCHOOL;

3. SELECT DISTINCT DESIGNATION FROM ADMIN;

4. SELECT TEACHERNAME.CODE

DESIGNATION FROM

SCHOOL.CODE = ADMIN.CODE

WHERE GENDER = MALE;