Question

Consider the following tables FACULTY .
Write SQL commands for the statements (i) to (v) and give outputs for SQL queries (vi) to (viii) i) To display details of those Faculties whose salary is greater than 12000ii) 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. iv) To display details of those courses which are taught by ‘Sulekha’. v) To display name of the Faculty whose salary is maximum. vi) Select COUNT(DISTINCT F_ID) from COURSES; vii) Select MIN(Salary) from FACULTY,COURSES where COURSES.C_ID = FACULTY.F_ID; viii) Select SUM(Fees) from courses Group By F_ID having count(*) > 1; ix) Select Fname, Lname from FACULTY Where Lname like “M%”;

Answer 1

Answer:

Consider the following tables FACULTY .

Write SQL commands for the statements (i) to (v) and give outputs for SQL queries (vi) to (viii) i) To display details of those Faculties whose salary is greater than 12000ii) 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. iv) To display details of those courses which are taught by ‘Sulekha’. v) To display name of the Faculty whose salary is maximum. vi) Select COUNT(DISTINCT F_ID) from COURSES; vii) Select MIN(Salary) from FACULTY,COURSES where COURSES.C_ID = FACULTY.F_ID; viii) Select SUM(Fees) from courses Group By F_ID having count(*) > 1; ix) Select Fname, Lname from FACULTY Where Lname like “M%”;

thanks for 6 points