Note: Database uses SQLite syntax.
SELECT * FROM "2019 Maryland state salaries";
Top Earners
SELECT first_name, last_name, organization, subtitle, ytd_gross_earnings FROM "2019 Maryland state salaries" ORDER BY ytd_gross_earnings DESC LIMIT 50;
Highest Paid In Organization
SELECT organization, first_name, last_name, max(ytd_gross_earnings) AS ytd_gross_earnings FROM "2019 Maryland state salaries" GROUP BY organization ORDER BY ytd_gross_earnings DESC;
Total Earnings By Organization
SELECT organization, sum(ytd_gross_earnings) AS "Total Organization Earnings(dollars)" FROM "2019 Maryland state salaries" GROUP BY organization ORDER BY sum(ytd_gross_earnings) DESC;
Average Salary Per Organization
SELECT organization, avg(annual_salary) AS "Average Annual Salary(dollars)" FROM "2019 Maryland state salaries" GROUP BY organization ORDER BY avg(annual_salary) DESC;
Overtime Per Organization
SELECT organization, avg(overtime_earnings) AS "Average Overtime(dollars)", max(overtime_earnings) AS "Max Overtime(dollars)", count(*) AS "Total Employees(numeric)" FROM "2019 Maryland state salaries" GROUP BY organization ORDER BY avg(overtime_earnings) DESC;
Number Of Employees In Organization
SELECT organization, pay_rate, count(*) AS "Employees(numeric)" FROM "2019 Maryland state salaries" GROUP BY organization, pay_rate ORDER BY pay_rate ASC, count(*) DESC;