Question 1 - Past Year - 2 Mark Questions - Chapter 9 - Structured Query Language

This question asked in CBSE Comptt., 2014

Consider the following tables SCHOOL and ADMIN and answer following questions:

Give the output of the following SQL queries:

Question 1 (i)

Select Designation Count (*) From Admin Group By Designation Having Count (*) <2;

Answer:

The query will display the designation and number of teachers grouped by their designation and having count less than 2.

Question 1(ii)

SELECT max (EXPERIENCE) FROM SCHOOL;

Answer:

The query will display the maximum value in the column EXPERIENCE of table SCHOOL.

Question 1(iii)

SELECT TEACHER FROM SCHOOL WHERE EXPERIENCE >12 ORDER BY TEACHER;

Answer:

The query will display the name of teachers who have more than 12 years of experience, in ascending order of names.

Question 1(iv)

SELECT COUNT (*), GENDER FROM ADMIN GROUP BY GENDER;

Answer:

The query will display the number of male and female teachers.