Reference no: EM131092579

Consider the following tables FACULTY and COURSES. Write SQL commands for the

FACULTY

F_ID Fname Lname Hire_date Salary

102 Amit Mishra 12-10- 1998 12000

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

COURSES

C_ID F_ID Cname Fees

C21 102 Grid Computing 40000

C22 106 System Design 16000

C23 104 Computer Security 8000

C24 106 Human Biology 15000

C25 102 Computer Network 20000

C26 105 Visual Basic 6000

i)To display details of those Faculties whose salary is greater than 12000.

ii) To display the details of courses whose fees is in the range of 15000 to 50000 (both values included).

iii)To increase the fees of all courses by 500 of “System Design” Course.

Iv)To display details of those courses which are taught by ‘Sulekha’ in descending order of courses.

v) Select COUNT(DISTINCT F_ID) from COURSES;

vi) Select MIN(Salary) from FACULTY,COURSES where COURSES