Which of the Following SQL Statements Would Extract the Employee

question 11

Multiple Choice

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

---

Definitions:

Base Year

The year with which other years are compared when constructing an index; the index equals 100 in the base year.

Price Index

A statistical measure that shows changes in the price level of a basket of goods and services over time, indicating the cost of living or inflation rate.

GDP Price Index

A comprehensive inflation measure of all goods and services included in the gross domestic product.

Final Goods

Products that are completed and ready for sale and consumption, as opposed to intermediate goods used in the production of another product.