LINQ Data Manipulation Series | Dataford Interview Questions

Tell me about implementing a series of data manipulation problems using LINQ or similar query constructs to filter and transform collections.

Use the Filevine matter activity data below. Write a SQL query that returns the requested result set.

Output

One row per matter.
Return the matter name, the most recent completed activity date, and a status label based on the matter's current state.
Include only matters with at least one completed activity.
Sort by most recent completed activity date descending, then matter name ascending.

matters

Column	Type	Description
matter_idPK	INT	Primary key for the matter
matter_name	VARCHAR(255)	Display name of the matter
is_active	BOOLEAN	Whether the matter is currently active
practice_area	VARCHAR(100)	Optional practice area label

activities

Column	Type	Description
activity_idPK	INT	Primary key for the activity
matter_id	INT	References the related matter
activity_type	VARCHAR(50)	Type of activity
activity_status	VARCHAR(20)	Current activity status
activity_date	DATE	Date the activity was completed or scheduled

Your question is LINQ Data Manipulation Series. 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.