Software Development Engineer 1
SQL Query using CTEs and Joins
Write a SQL query using Common Table Expressions (CTEs) and SQL joins to retrieve specific relational data.
This question was asked in
Hopscotch Software Development Engineer 1 Interview Experience
The candidate completed a multi-round interview process for a software role at Hopscotch, consisting of three primary rounds: a Phone Screening, a Technical Interview, and a Managerial Round. The questions evaluated core backend competencies, including Java, Spring Boot, DSA problems (such as Valid Parentheses and Time-Based Key-Value Store), SQL CTEs, and Low-Level Design. Overall, the interview process at Hopscotch was comprehensive, testing both practical backend project experience and fundamental technical problem-solving skills.