Shopify | Senior Data Engineer (Senior) | Sql | Phone Screen

I encountered some SQL questions that differed from what I usually work on, so I'd like to share my version as feedback. The position is for a Data Engineer (DE). The interview lasted one hour and was scheduled conveniently online through a slot booking system. They provided only two tables and the test was conducted on coderpad, where I had to run the queries and show results. There were four questions in total. The...