1. What is the SQL to do this result?

You are given the following tables:CourseCourseID Description CreditsCS101 Computer Science I 3CS201 Elementary Data Structures 3ENGL210 Technical Writing 3RegistrationSID CourseID SemID Instructor Grade282712 ENGL210 201701 H. Zacny B+362112 CS101 201701 K. Ross C652123 CS403 201603 K. Ross AStudentSID Lname Fname Major986223 Smith Janet Chemistry362112 Williams Henry Computer Science282712 Jones John English LiteratureWhat would the following SQL Select statement produce for output?select course.Description,registration.SID,registration.grade, student.lnamefrom registrationinner join courseon registration.courseID = course.courseIDinner join student on registration.sid = student.sidSelect one:a.No output, since this query cannot be performedb.Technical Writing 282712 B+ Jonesc.Technical Writing 282712 B+ JonesComputer Science I 362112 Williams Cd.Technical Writing 282712 B+ JonesComputer Science I 362112 Williams CNull 652123 Null A

Question 28: (1.00) Select NULLIF(1,1). This SQL statement returns: NULL 1 0 A 2

Question 5When querying a table called Teachers that contains a list of teachers and the city they teach in, which of the following queries will return the number of teachers from each city?1 pointSELECT distinct(City) FROM Teachers SELECT City, count(City) FROM TeachersSELECT City, count(City) FROM Teachers GROUP BY CitySELECT City, distinct(City) FROM Teachers GROUP BY City6.Question 6You want to retrieve a list of employees by first name and last name for a company that are between the ages of 30 and 50. Which clause would you add to the following SQL statement: SELECTFirst_Name,Last_Name, Age FROM Company1 pointWHERE Age > 30IF Age >=30 AND Age <=50WHERE Age < 30WHERE Age >=30 AND Age <=50

Consider the table Employee given below: EmpId EmpName Salary DeptId200 Alex 30000 100201 Tom 20000 101202 Dick 40000 100202 Harry 15000 102205 Mary 50000 101206 Karl 40000 101SELECT EmpName FROM Employee WHERE Salary > ALL (SELECT Salary FROM Employee WHERE DeptId = 100);What will be the outcome of the query given above?

.Question 12How many aggregate functions are in SQL?0 / 1 point6534