Question

Which query will correctly obtain the empID of employees whose hourly wage is greater than 15.00 and no more than 18.00? SELECT empID FROM personnel WHERE hourlyWage BETWEEN 15.00 AND 18.00 SELECT empID FROM personnel WHERE hourlyWage BETWEEN 15.00 AND <= 18.00 SELECT empID FROM personnel WHERE hourlyWage > 15.00 AND hourlyWage <= 18.00 SELECT empID FROM personnel WHERE hourlyWage >= 15.00 AND <= 18.00

Answer 1

SELECT empID FROM personnel WHERE hourlyWage > 15.00 AND hourlyWage <= 18.00

Step-by-step explanation:

• In SQL, SELECT is used to display particular rows and columns or all columns and rows based on conditions imposed. * is used to all columns otherwise column names to be displayed are mentioned.

• WHERE condition is used to impose conditions on rows to display. For eg. to display employees having salary less than 40,000,etc.
• BETWEEN clause is also used to filter out a range but the values are inclusive both start and end. For example - BETWEEN 20 AND 40 , then rows with value 20 and 40 are also included.
• But in this query we need to find hourlwage >15 so we did not use BETWEEN clause and manually checked conditions for >15 and <=18 and joined them using AND keyword.