After applying online, I was sent a timed HackerRank test that I had 3 hours to complete. The test consisted of 6 open-ended questions of increasing difficulty where I had to write SQL queries to obtain the requested data. The first few questions were relatively easy and involved simple aggregations, but the latter ones required writing more complex queries using subqueries, aggregations, and window functions. I managed to finish the test in an hour. A couple of weeks later, I received an automated rejection email stating that they already hired someone else for the role.