Read 4 questions in a Coderpad and solve them with SQL in under 20 minutes
Anonymous
Typical questions, but difficult because of time pressure. It was difficult for me to read 4 questions, write 4 solutions, and discuss 4 answers in 20 minutes. I finished 2.5 problems. SQL problems were complex involving case statements, left joins, aggregates, subqueries, and date-time conversions. You can “google”, but this is mostly a distraction and will waste time. Just know SQL syntax and how to solve these problems automatically. Practice with a whiteboard or notepad so you aren’t tempted to build statements modularly. In my opinion, this was very difficult as far as DS SQL tests go, but might be relevant to their needs.
Check out your Company Bowl for anonymous work chats.