Querying San Francisco Public Worker Salary
You have the following dataset containing salaries for public workers of San Francisco, CA. Let's assume this data is in a table called sf_salaries.
Can you write a SQL query to find the top 3 highest paid and top 3 lowest paid job titles?
|Column Name||Column Type||Short description|
|Id||int||The primary key of this table.|
|EmployeeName||string||The full name of the employee.|
|JobTitle||string||The title of the job the person does.|
|BasePay||double||The base amount of money the employee earns per year.|
|OvertimePay||double||The amount of money earned for the whole year for work done overtime.|
|OtherPay||string||Extra money coming from other activities.|
|Totalpay||double||The total without benefits.|
|TotalPayBenefits||double||Total pay with benefits.|
|Year||int||The year when the money was paid out.|
|Agency||string||Always is 'San Francisco'.|
Subscribe to premium account to see the solution.Get premium now