JP Morgan

Write a function that replaces all characters in a list except for a given character

Given two dataframes (df1: id, name and df2: id, country, address, city, count), join them, filter for rows where country = 'Singapore', and pivot the output. Sort cities in descending order of population count

Hierarchical Employee-Manager Query - navigate hierarchy with head of company as employee_id = 1