Consider these following tables and only solve the query. Tables: 1) student: s_no (primary key), student_name, course_no (foreign key), age 2) courser-course-no (primary key), course-name.

Consider these following tables and only solve the query. Tables: 1) student: s_no (primary key), student_name, course_no (foreign key), age 2) courser-course-no (primary key), course-name. Query: Display all the student name, course name and also age of the students, whose age is between 23 to 27 and course having 'BCA'. Find out the students whose age is maximum.

Give a table:Student (studentId, name, major) Primary key is [studentId, major].Which code snippet will list out students that the major not equals 'IT'?SELECT * FROM Student HAVING major <> 'IT'All of the aboveSELECT * FROM Student s WHERE s.major != 'IT'SELECT * FROM Student GROUP BY major HAVING major <> 'IT'

Consider following schema and write SQL statements for given queries using subqueries.Faculty (f_id, f_name, address, city, state, age, salary, d_id)Department (dep_id, d_name, course, location, sub_code, subject)Student (enrl_no, s_name, s_address, s_city, s_state, s_age, course, f_id, hobby)Create tables with Primary Key, foreign key constraints in given schemas.1) Display name of faculties and students who are not living in the same city.2) Find out how much amount is spent on faculties as their salary who are working in 'IT Engineering' Department.3) Display department name, course, subject code and subject of person who have enrolled as a student.4) Display id and name of faculty who are working in 'IT Engineering' department and have a salary more than Rs. 60000

Students Table Surname   First_Name   Student_No   Dept_No   Year Duke Fitzroy 1 4 2Al-Essawy Zaid 2 4 2Ayton Phil 3 3 1Patel Mahesh 4 2 1Jones Gareth 5 2 1Scott Gavin 6 2 2CREATE VIEW Freshman     AS Select * From Students Where Year = 2;Considering the above Students table and Freshman view, what will be the result of the following SQL query:Select * From Freshman Where Dept_No=2;Question 8Select one:a. Surname   First_Name   Student_No   Dept_No   Year Duke Fitzroy 1 4 2Al-Essawy Zaid 2 4 2b. Surname   First_Name   Student_No   Dept_No   Year PatelMahesh4 2 1JonesGareth5 2 1 Scott  Gavin  6  2  2c. Surname   First_Name   Student_No   Dept_No   Year Scott Gavin6 2 2d. Surname   First_Name   Student_No   Dept_No   Year PatelMahesh4 2 1Jones Gareth 5

Given 3 tables, students(id, name) , courses(id, name) , grades(id, course_id, student_id, grade), for each student, get all the courses that he/she is enrolled in along with the grade he/she scored for each course. Order the result by the student name in ascending order and if there is a tie, break it with the course name in ascending order and if there is a tie break it with the grade in ascending order. Your query should output a table with the following columns (name, course, grade).