Consider the given table Faculty and answer the questions that follow

Q. Consider the given table Faculty and answer the questions that follow:

Table: FACULTY

 

 
	 
F_ID
 
	 
F_Name
 
	 
L_Name
 
	 
Hire_date
 
	 
Salary
 
 
 
	 
102
 
	 
Amit
 
	 
Mishra
 
	 
12-10-1998
 
	 
10000
 
 
 
	 
103
 
	 
Nitin
 
	 
Vyas
 
	 
24-12-1994
 
	 
8000
 
 
 
	 
104
 
	 
Rakshit
 
	 
Soni
 
	 
18-5-2001
 
	 
14000
 
 
 
	 
105
 
	 
Rashmi
 
	 
Malhotra
 
	 
11-9-2004
 
	 
11000
 
 
 
	 
106
 
	 
Sulekha
 
	 
Srivastava
 
	 
5-6-2006
 
	 
10000
 
 

(a) To display the details of those Faculty members whose salary is higher than 12000.

(b) To display the details of Faculty members whose salary is in the range of 8000 to 12000 (both values included).

(c) Count the number of different id from faculty.

(d) Count the number of faculty members getting salary as 10000.

(e) Display details of those faculty members whose names start with S.

(f) Display all records in descending order of Hire date.

(g) Find the maximum and the minimum salary.

Answer :-

(a) Select * from Faculty where salary > 12000 ;
(b) Select * from Faculty where salary between 8000 and 12000 ;
(c) Select count( F_ID ) from Faculty ;
(d) Select count( * ) from Faculty where Salary = 10000 ;
(e) Select * from Faculty where F_Name like “S%” ;
(f) Select * from Faculty order by Hire_date DESC ;
(g) Select MAX( Salary ), Min ( Salary ) from Faculty ;