Basic SQL Query Writing

Q: Write a basic SQL query to satisfy a simple retrieval requirement (e.g., fetch rows meeting a filter/join condition). A: Interviewers in this round typically hand you a small schema (2-3 tables) and ask for straightforward SELECT/JOIN/WHERE/GROUP BY queries - e.g., 'find all customers who placed more than N orders' or 'list products never ordered'. Demonstrate correct use of INNER/LEFT JOIN depending on whether unmatched rows should be included, GROUP BY with HAVING for aggregate filters, and be ready to explain how you'd verify the query against edge cases (nulls, duplicate rows).