← Back ← Top 3 / dept Monthly LAG →

Date functions — dialect cheat sheet

What staff-level SQL screens expect you to say out loud

SQL drill • Reference

For a Staff Engineer loop, be fluent in calendar bucketing in the engine you claim. Step through the same idea in PostgreSQL, MySQL, and SQL Server — then use it in the monthly sales + LAG drill.

Interview bar
EXTRACT · truncate month · “today”
Step 0/5Line
Dialect comparison (same intent)
Press Step or Play.
Ready
Each step highlights one row of the mental table interviewers expect.