SQL Query for Items Expiring This Week | Dataford Interview Questions

Write SQL queries: given a table QUICKTRACE with columns Sl_No, Item, expiry date, and quantity, retrieve all groceries that are about to expire this week.

Assume the current calendar week runs from Monday through Sunday. Include rows expiring on either boundary date and exclude rows with a missing expiry date.

Output

Return Sl_No, Item, expiry date, and quantity.
Include one row per matching grocery, ordered by expiry date ascending and Sl_No ascending.

Schema

QUICKTRACE

Column	Type	Description
Sl_NoPK	INT	Unique serial number for the grocery record
Item	VARCHAR(100)	Grocery item name
expiry date	DATE	Date on which the grocery expires
quantity	INT	Available quantity of the grocery item

Your question is SQL Query for Items Expiring This Week. Start with the requirements and the one table 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