Airbnb Interview Question

For the HackerRank assessment, they will give a table schema and base SQL questions on that and execution will test it on a few test cases. Similar for the python question as well. In my case, the question just asked the last same SQL question but the code had to be implemented in python.