Employee Salaries Analysis

Salary information for employees across various departments

@kaggle.sahirmaharajj_employee_salaries_analysis

Table List

1 table(122.46 KB)

Employee Salaries

@kaggle.sahirmaharajj_employee_salaries_analysis.employee_salaries

122.46 KB
10291 rows
8 columns

department Department	department_name Department Name	division Division	gender Gender	base_salary Base Salary	overtime_pay Overtime Pay	longevity_pay Longevity Pay	grade Grade
ABS	Alcohol Beverage Services	ABS 85 Administration	M	175873			M2
ABS	Alcohol Beverage Services	ABS 85 Administration	M	145613.36			M3
ABS	Alcohol Beverage Services	ABS 85 Administration	F	136970			M3
ABS	Alcohol Beverage Services	ABS 85 Administrative Services	F	89432.694		2490	21
ABS	Alcohol Beverage Services	ABS 85 Administrative Services	F	78947	456.68	6257.7	16
ABS	Alcohol Beverage Services	ABS 85 Administrative Services	F	98228	518.8	998.28	21
ABS	Alcohol Beverage Services	ABS 85 Administrative Services	F	82405.3864	549.2		18
ABS	Alcohol Beverage Services	ABS 85 Administrative Services	M	93986	1187.06	2452.94	N20
ABS	Alcohol Beverage Services	ABS 85 Administrative Services	F	149464.15		9021.82	18
ABS	Alcohol Beverage Services	ABS 85 Administrative Services	M	117424			N25


CREATE TABLE employee_salaries (
  "department" VARCHAR,
  "department_name" VARCHAR,
  "division" VARCHAR,
  "gender" VARCHAR,
  "base_salary" DOUBLE,
  "overtime_pay" DOUBLE,
  "longevity_pay" DOUBLE,
  "grade" VARCHAR
);