Interpreting Operational Trends | Dataford Interview Questions

Interpret this set of operational performance data and identify the primary trend.

Write a PostgreSQL query using the supplied operational performance records. Calculate the monthly completion rate and compare each month with the preceding month. Exclude records without a completed-case value or a positive target.

Output

One row per reporting month.
Columns: reporting_month, completion_rate, previous_completion_rate, and trend.
Show rates as percentages rounded to two decimal places.
Order chronologically by reporting_month; label the first month as baseline, followed by improving, declining, or stable.

Schema

facilities

Column	Type	Description
facility_idPK	INT	Unique operational facility identifier
facility_name	VARCHAR(100)	Facility name
region	VARCHAR(50)	Operational region

operational_performance

Column	Type	Description
performance_idPK	INT	Unique performance record identifier
facility_id	INT	Facility associated with the record
reporting_month	DATE	First day of the reporting month
completed_cases	INT	Number of completed operational cases
target_cases	INT	Target number of cases for the period

Your question is Interpreting Operational Trends. 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