Write SQL queries against a schema

viaGlassdoor

Prompt Given a schema, write SQL queries to answer business questions — joins across tables, aggregation, and filtering.

Be ready to discuss / write

INNER vs LEFT/RIGHT joins and when each is correct.
GROUP BY with aggregates (COUNT/SUM/AVG), HAVING vs WHERE.
Window functions (ROW_NUMBER, RANK, running totals) for top-N-per-group style questions.
Indexing and how it affects query plans; spotting and avoiding full scans.

Add a follow-up question they asked

No follow-ups yet. Be the first to add one.

asked …