Question

Consider the following table and write SQL queries for the following questions. TABLE: College RollNo Name Class Branch 1846 Rahul MBA Pune 2468 Ajay BBA Delhi 2842 Amay BCA Delhi 2431 Yash BA Mumbai 1431 Jayesh BBA Pune i. Display the RollNo and Name of BBA students. ii. Display the table in ascending order of student names. iii. Change the branch of the student with roll number 2431 to Pune.​

Answer 1

Answer:

(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.F_ID = FACULTY.F_ID;Read more on Sarthaks.com - https://www.sarthaks.com/294964/consider-the-following-tables-faculty-and-courses-write-sql-commands-for-the-statements