[Go to site: main page, start]
Scribd
Upload
7 views1 page

SQL Queries for Teacher Salary Analysis

The document contains a set of SQL queries based on a 'Teacher' table with various attributes. The queries include filtering teachers by salary, class incharge, gender, and join date, as well as listing unique classes and calculating annual salaries. Each query addresses specific conditions to retrieve relevant teacher information.

Uploaded by

avadheshkushwaha9369
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views1 page

SQL Queries for Teacher Salary Analysis

The document contains a set of SQL queries based on a 'Teacher' table with various attributes. The queries include filtering teachers by salary, class incharge, gender, and join date, as well as listing unique classes and calculating annual salaries. Each query addresses specific conditions to retrieve relevant teacher information.

Uploaded by

avadheshkushwaha9369
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Q2. Write SQL queries on the basis of following table.

Relation: Teacher

TName Incharge Salary Gender Dateofjoin

Rahul XII 12000 M 2015-02-11

Mehul XII 12500 M 2014-12-21

Manisha XI 13500 F 2016-10-22

Sujoy XI 21050 M 2016-10-22

Sonakshi XII 21000 F 2015-08-19

Suman X 16950 F 2018-06-26


i. Show information of teachers having salary more than
20000.
ii. List teachers who are incharge of classes X or XII.
iii. List teachers teaching class X or having salary more than
10000.
iv. View those records where salary is between 10000 and
20000.
v. List female teachers having salary 21000.
vi. List different classes available in above table (no
duplicates).
vii. List salary and names of teachers having salary less than
15000 or more than 20000.
viii. List name, salary and annual salary (salary*12) of all
teachers.
ix. List name of all teachers teaching class XII.
X. List name and salary of all teachers who joined before
‘2016-10-01’.

You might also like