First question in the assignment is to write a SQL query, that includes sub-queries, date ranges, joins, filtering - nothing too difficult. Second question is about writing code to send HTTP requests to some endpoint, get back some JSON, and parse / filter the data. Quite easy if you are familiar with a high level language like python. Third question is like a hard leetcode, involving binary search and finding a maximum. Very similar to this question: https://leetcode.com/discuss/interview-question/4537618/Jobs-scheduling/
Check out your Company Bowl for anonymous work chats.