Question

Write the outputs of the SQL queries based on the relations Teacher and Placement given below:

Table: Teacher

T_ID	Name	Age	Department	Date_of_join	Salary	Gender
1	Arunan	34	Computer Sc	2019-01-10	12000	M
2	Saman	31	History	2017-03-24	20000	F
3	Randeep	32	Mathematics	2020-12-12	30000	M
4	Samira	35	History	2018-07-01	40000	F
5	Raman	42	Mathematics	2021-09-05	25000	M
6	Shyam	50	History	2019-06-27	30000	M
7	Shiv	44	Computer Sc	2019-02-25	21000	M
8	Shalakha	33	Mathematics	2018-07-31	20000	F

Table: Placement

P_ID	Department	Place
1	History	Ahmedabad
2	Mathematics	Jaipur
3	Computer Sc	Nagpur

1. SELECT Department, avg(salary) FROM Teacher GROUP BY Department;
2. SELECT MAX(Date_of_Join), MIN(Date_of_Join) FROM Teacher;
3. SELECT Name, Salary, T.Department, Place FROM Teacher T, Placement P WHERE T.Department = P.Department AND Salary>20000;
4. SELECT Name, Place FROM Teacher T, Placement P WHERE Gender = ’F’ AND T.Department = P.Department;

Answer 1

1. SELECT Department, avg(salary) FROM Teacher GROUP BY Department;
   

   Department	Avg(Salary)
   Computer Sc	16500.00
   History	30000.00
   Mathematics	25000.00

2. SELECT MAX(Date_of_Join), MIN(Date_of_Join) FROM Teacher;
   

   Max(Date_of_Join)	Min(Date_of_Join)
   2021-09-05	2017-03-04

3. SELECT Name, Salary, T.Department, Place FROM Teacher T, Placement P WHERE T.Department = P.Department AND Salary>20000;
   

   Name	Salary	Department	Place
   Randeep	30000	Mathematics	Jaipur
   Samira	40000	History	Ahmedabad
   Raman	25000	Mathematics	Jaipur
   Shyam	30000	History	Ahmedabad
   Shiv	21000	Computer Sc	Nagpur

4. SELECT Name, Place FROM Teacher T, Placement P WHERE Gender = 'F' AND T.Department = P.Department;
   

   Name	Place
   Samira	Ahmedabad
   Suman	Ahmedabad
   Shalaka	Jaipur