Write the SQL and give output in from ORACLE for the following queries, (Q 15 q 21)

Q 15. Give the count of students who got better grade than Apple.

Q16. Give the name of faculty that have exactly one E in their name

Q 17. Give the salaries of faculty who are teaching student DRUM

Q18 Give the count of grades for INSS421. (i.e, How many A;s, how many Bs etc..)

Q 19. Assume a total of 12 classrooms. How many empty classes are available each day on listed class times? Ex: If there are 4 classes scheduled on W5:30 then there are 12 - 4 = 8 empty classes available on W5:30

Q 20 Give the names of students who are taking at least two classes in RM 219BC.

Q 21. Give the names of students and their grades who got better grades than the highest grade by GRAY in classes taught by KEEN

FACULTY1

F_NUM	F_NAME	RANK	D_NAME	SALARY
112	DWIGHT	PROFESSOR	MIS	142201.81
113	LEE	ASSISTANT PROF	MIS	92012.94
M11	PITTA	PROFESSOR	MKT	133837
114	CORY	ASSOCIATE PROF	MIS	125472.19
MK1	JACKET	ASSOCIATE PROF	FIN	108742.56
MK2	KEEN	LECTURER	FIN	75283.31
MK3	GARY	PROFESSOR	MKT	135509.96
MGT1	HULU	LECTURER	MGT	125472.19
II5	DARWN	PROFESSOR	MGT	83648.13

CLASS1

C_NAME	C_TIME	F_NAME	C_ROOM	SEMESTER
INSS300	M5:30	DWIGHT	219BC	FALL15
INSS300	T5:30	KEEN	216BC	FALL15
MKT300	M5:30	LEE	112BC	SP15
MKT300	W:5:30	LEE	112BC	SP15
INSS421	T5:30	CORY	212BC	FALL15
FIN300	TH5:30	KEEN	219BC	FALL15
INSS300	W:5:30	CORY	219BC	FALL15
INSS300	F5:30	CORY	216BC	FALL15
INSS422	F5:30	KEEN	219BC	FALL15

GRAD1

S_NAME	C_NAME	GRADE
LARRY	INSS300	B
LARRY	FIN300	A
SONY	INSS300	C
SONY	INSS421	C
GRAY	INSS300	C
GRAY	INSS421	D
TRUDY	INSS300	B
DRUM	INSS421	A
DRUM	FIN300	B
PURI	INSS422	C
APPLE	INSS422	C
LARRY	INSS422	C
PURI	FIN300	C
SANDI	INSS300	A
PURI	INSS300	B