Multiple choice

Select * from employees where (total_sales-25000) between (select avg(total_sales) from employees) and (select avg(total_sales)*1.2 from employees); What will be the output of the above query? Table: Employees(emp_id,fname,lname,salary,total_sales)

  1. It retrieves the details of employees whose total sales volume is greater than the average sales volume.

  2. It lists those employees whose total sales volume minus 25000 is between the average sales volume and 120 percent of the average.

  3. It lists those employees whose total sales volume minus 25000 is between the average sales and 1.2% of the sales.

  4. It lists those employees whose total sales volume minus 25000 is between the average sales and 1.2% of the average.

  5. None of these
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Condition: (total_sales-25000) Implies whose total sales volume minus 25000(select avg(total_sales) from employees) and (select avg(total_sales)*1.2 from employees) Implies the average sales volume and 120 percent of the average.

Keep practicing — related questions