In creating a query, a student entered the following criteria for the date field.  > = 05/11/2021 and < = 05/14/2021 . The output will show days*1 pointAfter 14th May 2021 onlyfrom 11th and 14th May 2021Before 11th May and after 14th May 2021between 14th May and 5th November 2021

Which filter outputs all records with values in the date column between '01-01-2015' (January 1, 2015) and '01-04-2015' (April 1, 2015)?1 pointWHERE date BETWEEN '01-01-2015', '01-04-2015';WHERE date < '01-04-2015';WHERE date BETWEEN '01-01-2015' AND '01-04-2015';WHERE date > '01-01-2015';

ind the difference between two dates in terms of number of days.input2021-05-012021-05-16

Which SQL query retrieves all records with dates falling within the current month?

This is used to get the day my daughter was born SELECT DAYNAME(<date_expression>)Group of answer choicesTrueFalse

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.