RoundsCorrowmere Clinics · Estmark synthetic data · seed 23

Ask

Questions are answered from the same definitions the operator uses. When a word has two meanings in the group, both answers come back, each with its owner, version and SQL.

How many no-shows last week?How many active patients do we have?Late cancellations todayAbnormal results this week

18 results according to the Lab manager (lab v1, this week (from Monday)).

Lab meaning

18

18 results

Lab manager (lab) · lab v1 · this week (from Monday)

Flag abnormal or critical, resulted in the period.

SELECT r.id AS result_id, r.test_code, r.flag, r.clinic_id, r.resulted_at
FROM results r
WHERE r.flag IN ('abnormal', 'critical') AND r.resulted_at >= TIMESTAMP '2026-11-16 00:00:00' AND r.resulted_at < TIMESTAMP '2026-11-16 13:00:00'
  AND r.resulted_at <= TIMESTAMP '2026-11-16 13:00:00'