SQL Inner Join Matching Rows | Dataford Interview Questions

Avnet's component fulfillment workflow records the matching status of shipment requests. Write a PostgreSQL query that returns only shipment records whose status is Matched.

Requirements

Return the shipment ID, requested part number, and matching status.
Include only rows where status equals Matched.
Order the results by shipment_id in ascending order.

Schema

component_shipments

Column	Type	Description
shipment_idPK	INTEGER	Unique shipment request identifier
part_number	VARCHAR(30)	Avnet component part number
customer_account	VARCHAR(40)	Customer account name
status	VARCHAR(20)	Shipment matching status
requested_quantity	INTEGER	Quantity requested

Your question is SQL Inner Join Matching Rows. 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

Avnet's component fulfillment workflow records the matching status of shipment requests. Write a PostgreSQL query that returns only shipment records whose status is Matched.

Requirements

Return the shipment ID, requested part number, and matching status.
Include only rows where status equals Matched.
Order the results by shipment_id in ascending order.

Schema

component_shipments

Column	Type	Description
shipment_idPK	INTEGER	Unique shipment request identifier
part_number	VARCHAR(30)	Avnet component part number
customer_account	VARCHAR(40)	Customer account name
status	VARCHAR(20)	Shipment matching status
requested_quantity	INTEGER	Quantity requested

Your question is SQL Inner Join Matching Rows. 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.