• #
  • 522552
  • #

Discover the world

Home Discover the world

Europe

SELECT SUM(SALARY), AVG(SALARY)

FROM EMPLOYEESTATISTICSTABLE;

This query shows the total of all salaries in the table, and the average salary of all of the entries in the

table.

SELECT MIN(BENEFITS)

FROM EMPLOYEESTATISTICSTABLE

WHERE POSITION = Manager;

This query gives the smallest figure of the Benefits column, of the employees who are Managers,

which is 12500.

SELECT COUNT(*)

FROM EMPLOYEESTATISTICSTABLE

WHERE POSITION = Staff;

This query tells you how many employees have Staff status (3).