Leetcode 2853 - Highest Salaries Difference - Solved by Everyday Data Science | ABSOLUTE difference

Опубликовано: 24 Октябрь 2024
на канале: Everyday Data Science

266

Question: https://leetcode.com/problems/highest...

SQL Schema:
Create table if not exists Salaries(emp_name varchar(30), department varchar(30),salary int)
Truncate table Salaries
insert into Salaries (emp_name, department, salary) values ('Kathy', 'Engineering', '50000')
insert into Salaries (emp_name, department, salary) values ('Roy', 'Marketing', '30000')
insert into Salaries (emp_name, department, salary) values ('Charles', 'Engineering', '45000')
insert into Salaries (emp_name, department, salary) values ('Jack', 'Engineering', '85000')
insert into Salaries (emp_name, department, salary) values ('Benjamin', 'Marketing', '34000')
insert into Salaries (emp_name, department, salary) values ('Anthony', 'Marketing', '42000')
insert into Salaries (emp_name, department, salary) values ('Edward', 'Engineering', '102000')
insert into Salaries (emp_name, department, salary) values ('Terry', 'Engineering', '44000')
insert into Salaries (emp_name, department, salary) values ('Evelyn', 'Marketing', '53000')
insert into Salaries (emp_name, department, salary) values ('Arthur', 'Engineering', '32000')

Pandas Schema:
data = [['Kathy', 'Engineering', 50000], ['Roy', 'Marketing', 30000], ['Charles', 'Engineering', 45000], ['Jack', 'Engineering', 85000], ['Benjamin', 'Marketing', 34000], ['Anthony', 'Marketing', 42000], ['Edward', 'Engineering', 102000], ['Terry', 'Engineering', 44000], ['Evelyn', 'Marketing', 53000], ['Arthur', 'Engineering', 32000]]
salaries = pd.DataFrame(data, columns=['emp_name', 'department', 'salary']).astype({'emp_name':'object', 'department':'object', 'salary':'Int64'})

#datasciencequestions #leetcodesolutions #dataengineering