← Amazon questions
Reported 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.

Related Amazon questions

Collected from public candidate posts and coding forums. Updated Nov 2026.