#81 Get the Latest Product Deliveries by Type

Companies:

OTR

Themes:

SQLJoinsAggregationPractice

Write a query that returns all latest product deliveries:

id | type | timestamp
delivery_1 bread 2020-01-01 09:00:00
delivery_2 bread 2020-01-02 10:00:00
delivery_3 milk 2020-01-01 11:00:00
delivery_4 milk 2020-01-05 09:30:00
delivery_5 oranges 2019-02-04 12:00:00

Expected result:
delivery_2 bread 2020-01-02 10:00:00
delivery_4 milk 2020-01-05 09:30:00
delivery_5 oranges 2019-02-04 12:00:00

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.