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';

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 SQL query retrieves all records with dates falling within the current month?

Which SQL clause is used to filter records?

Which temporal function extracts the year from a date in SQL?

Question 4In what way is the SQL WHERE clause similar to filtering in spreadsheets?1 pointBoth the WHERE clause and spreadsheet filters can be used to create pivot tables.Both the WHERE clause and spreadsheet filters return a subset of data based on specified criteria. Both the WHERE clause and spreadsheet filters enable efficient sorting of data.Both the WHERE clause and spreadsheet filters enable data professionals to remove duplicate columns.