SQL Query for Expiring Groceries | Dataford Interview Questions

HashedIn's QuickTrace inventory surface needs a daily view of groceries that are still available and will expire during the remainder of the current calendar week. Write a PostgreSQL query using the tables below.

Requirements

Return groceries whose expiry date is from today through the end of the current week, excluding already expired items.
Include groceries with no matching store record, showing a NULL store name.
Return the grocery name, category, quantity, expiry date, store name, and an expiry_status of Expires today or Upcoming.
Order by expiry date ascending, then grocery name ascending.

Schema

quicktrace_groceries

Column	Type	Description
grocery_idPK	INT	Unique grocery inventory record identifier
grocery_name	VARCHAR(100)	Name of the grocery product
category	VARCHAR(50)	Grocery category
quantity	INT	Available inventory quantity
expiry_date	DATE	Date on which the grocery expires
store_id	INT	Associated QuickTrace store identifier

quicktrace_stores

Column	Type	Description
store_idPK	INT	Unique store identifier
store_name	VARCHAR(100)	QuickTrace store name
city	VARCHAR(60)	City where the store operates

Your question is SQL Query for Expiring Groceries. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem