Which of the following SQL statements would extract the employee number and date for every instance that an employee worked more than 8 hours any particular day?
A)SELECT Employee_No, Date FROM BILLING_HOURS
WHERE Hours8
B)QUERY Employee_No, Date FROM BILLING_HOURS
WHERE Hours8
C)SELECT Employee_No, Date WHERE Hours8
D)QUERY BILLING_HOURS SELECT Employee_No, Date
WHERE Hours8

Question

Which of the following SQL statements would extract the employee number and date for every instance that an employee worked more than 8 hours any particular day?
A)SELECT Employee_No, Date FROM BILLING_HOURS
WHERE Hours>8
B)QUERY Employee_No, Date FROM BILLING_HOURS
WHERE Hours>8
C)SELECT Employee_No, Date WHERE Hours>8
D)QUERY BILLING_HOURS SELECT Employee_No, Date
WHERE Hours>8

Quizplus · Accepted Answer

This SQL statement selects the Employee_No and Date columns from the BILLING_HOURS table where the Hours column is greater than 8, which fulfills the requirement of extracting the employee number and date for every instance that an employee worked more than 8 hours any particular day. The other options have syntax errors or incorrect order of clauses.

Which of the Following SQL Statements Would Extract the Employee