Which statement about the SELECT query design provided above is correct?Note: the Semester field contains either F for Fall semesters or S for Spring semestersthe Semester Year field contains 4-digit numbers representing the yearQuestion 5Select one:a.None of the statements are correct.b.Display the list of enrolments between 2011 and 2013.c.Display the list of enrolments for 2011, as well as for 2013. d.Display the list of enrolments before 2011 or after 2013.

Multi Choice Type QuestionWhich of the following should be used to find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester?Marks : 1Negative Marks : 0Answer hereSELECT DISTINCT course id FROM SECTIONWHERE semester = ’Fall’ AND YEAR= 2009 AND course id NOT IN (SELECT course id FROM SECTION WHERE semester = ’Spring’ AND YEAR= 2010);SELECT DISTINCT course_idFROM instructorWHERE name NOT IN (’Fall’, ’Spring’);SELECT course idFROM SECTIONWHERE semester = 'Spring' AND YEAR= 2010);SELECT COUNT (DISTINCT ID)FROM takesWHERE (course id, sec id, semester, YEAR) IN (SELECT course id, sec id, semester, YEARFROM teaches

Which of the following are the correct syntaxes for displaying the StudentName and Department from Student table?Select one or more:a.SELECT StudentName, Department FROM Student;b.select studentname, department FROM STUDENT;c.SELECT STUDENTNAME, DEPARTMENT FROM Student;d.select studentname, department FROM Student;

Which code is best to provide the age of each students recorded in the tblstudents?Group of answer choicesSELEC YEAR(NOW()) - YEAR(BDATE) FROM TBLSTUDENTSSELECT STUDNAME AS "NAME OF THE STUDENT", YEAR(NOW()) - YEAR(BDATE) FROM TBLSTUDENTSSELECT YEAR(NOW()) - YEAR(BDATE) AS AGE FROM TBLSTUDENTSSELECT STUDNAME AS "NAME OF THE STUDENT", YEAR(NOW()) - YEAR(BDATE) AS AGE FROM TBLSTUDENTS

The algorithm below determines whether a given year is a leap year.If year is not divisible by 4, set leap_year to falseElse if year is not divisible by 100, set leap_year to trueElse if year is not divisible by 400, set leap_year to falseElse, set leap_year to true.Which of these tables correctly shows the results of this algorithm on the given values of year?Choose 1 answer:Choose 1 answer:(Choice A)   year leap_year1900 false1984 true2000 false2002 falseAyear leap_year1900 false1984 true2000 false2002 false(Choice B)   year leap_year1900 false1984 true2000 true2002 falseByear leap_year1900 false1984 true2000 true2002 false(Choice C)   year leap_year1900 true1984 true2000 false2002 falseCyear leap_year1900 true1984 true2000 false2002 false(Choice D)   year leap_year1900 true1984 true2000 true2002 falseDyear leap_year1900 true1984 true2000 true2002 false

Write a SELECT statement that answers this question:Which instructors have an annual salary that’s greater than the average annual salary for all instructors?Display the Last Name, First Name, and Annual Salary columns for each Instructor. Order in descending Annual Salary.