SQL for Monthly Shipments | Dataford Interview Questions

Write a SQL query to retrieve the total number of shipments per month from a logistics database for DP world.

Use the shipments table and include only records with a non-null shipment date.

Output

shipments

Column	Type	Description
shipment_idPK	INT	Unique identifier for the shipment
shipment_date	DATE	Date on which the shipment was recorded

Your question is SQL for Monthly Shipments. 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.

Write a SQL query to retrieve the total number of shipments per month from a logistics database for DP world.

Use the shipments table and include only records with a non-null shipment date.

shipments

Column	Type	Description
shipment_idPK	INT	Unique identifier for the shipment
shipment_date	DATE	Date on which the shipment was recorded

Your question is SQL for Monthly Shipments. 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.