Most Recent Transaction
Medium
Unlock detailed company stats for this questionUpgrade
Given an e-commerce database with the schema shown below, write a query to fetch the product name and stock of the most recently purchased product
Your query should return a result in the following format:
id | name | stock ----+---------+------- int | varchar | int
This question tests your ability to make use of date fields and the ORDER BY clause alongside LIMIT in order to get the most recently sold item.
The query will output a result in the following format:
id | name | stock ----+-------------+------- 4 | Notorola X7 | 396
Interview experiences
1 sharedRelated courses
Course
Course