← Amazon questionsReported in a candidate post, Apr 2021
Extract date from a datetime field, group by, then join another table
Filed under Amazon
Write a SQL query that takes only the date part of a date-time column, groups by it, and joins another table to bring in extra information.
You've read your 3 free write-ups
Sign up free to keep reading. Your account opens the first 10 questions of every company.
Collected from public candidate posts and coding forums. Updated Nov 2026.