Question

Which query will return the title and hourly wage of all employees whose hourly wage is at least 10.00 but not more than 20.00? SELECT title, hourlyWage FROM personnel WHERE hourlyWage BETWEEN 10.00 AND <= 20.00 SELECT title, hourlyWage FROM personnel WHERE hourlyWage >= 10.00 AND hourlyWage <= 20.00 SELECT title, hourlyWage FROM personnel WHERE hourlyWage >= 10.00 AND <= 20.00 SELECT title, hourlyWage FROM personnel WHERE hourlyWage BETWEEN 10.00 AND 20.00

Answer 1

Select title,hourlywage>=10 AND hourlywage<=20

Step-by-step explanation:

The above mentioned option is correct option because hourlywage is the variable that should be mentioned with both upper and lower limits of the wage.