Israel Defense Forces Full Stack Developer interview questions

I received an online SQL test, typically through a platform like HackerRank or Codility. The test included 2-3 questions where I had to: Write SQL queries to retrieve specific information. Perform aggregate operations like GROUP BY, SUM, AVG. Work with JOIN operations across multiple tables. Solve questions involving window functions like RANK(), ROW_NUMBER(). Time allotted: 60-90 minutes.