Question

5
VI. SELECT AVG(Salary) FROM Teacher GROUP BY Gender;
24 Consider the table projects given below.
Write commands in SQL for (i) to (iv). Output for (v)
ID
ProjName ProjSize StartDate EndDate
1
Payroll-MMS Medium 2006-03-17 2006-09-16
2
Payroll-ITC Large 2008-02-12 2008-01-11
3
IDMgmt LITL Large 2008-06-13 2009-05-21
4
Recruit-LITL Medium 2008-09-18 2008-06-01
5
IDMgmt-MTC
Small 2007-01-15 2007-01-29
Recruit.ITC Medium 2007-03-01 2007-06-28
Cost
60000
500000
300000
50000
20000
50000
6
(1) To display all information about projects of Medium ProjSize.
(ii) To list the ProjSize of projects whose ProjName ends with LITL.
(iii) To list ID, name, size and Cost of all the projects in descending order of
StartDate.
(iv) To count the number of projects of cost less than 100000.
(V) SELECT sum(Cost) FROM projects;

Answer 1

Answer:

please send a softcopy

Explanation: