Question $1(4$ points$)$

Listen

Consider a table EMPLOYEES with an attribute HIRING$\_$DATE that holds the date where an employee was hired as a date data type. Which of the following queries display the employees hired before $2019?$

SELECT $*$

FROM EMPLOYEE

WHERE HIRING$\_$DATE $<mn\; id="EditorElement\_902193">2</mn><mn\; id="EditorElement\_902194">0</mn><mn\; id="EditorElement\_902195">1</mn><mn\; id="EditorElement\_902196">9</mn>$

SELECT $*$

FROM EMPLOYEE

WHERE YEAR$($HIRING$\_$DATE$)<mn\; id="EditorElement\_902127">2</mn><mn\; id="EditorElement\_902128">0</mn><mn\; id="EditorElement\_902129">1</mn><mn\; id="EditorElement\_902130">9</mn>$

SELECT NAME

FROM EMPLOYEE

WHERE TO$\_$DATE$($HIRING$\_$DATE, $\text{'}\%$Y$\text{'})<mtext\; id="EditorElement\_902109"></mtext><mn\; id="EditorElement\_902110">2</mn><mn\; id="EditorElement\_902111">0</mn><mn\; id="EditorElement\_902112">1</mn><mn\; id="EditorElement\_902113">9</mn>$

SELECT $**$

FROM EMPLOYEE

WHERE DATE$\_$FORMAT$($HIRING$\_$DATE $-2019,\text{'}\%Y^{\text{'}}\text{'})>0$