Public Broadcast System

citizens — active schema

CREATE TABLE citizens (
  id             INTEGER PRIMARY KEY,
  full_name      TEXT NOT NULL,
  aadhar_number  TEXT UNIQUE,
  age            INTEGER,
  phone_number   TEXT,
  email          TEXT,
  system_role    TEXT,
  occupation     TEXT,
  annual_income  REAL,
  cibil_score    INTEGER,
  state_region   TEXT,
  blood_group    TEXT,
  created_at     DATETIME
);

Example SQL condition: age > 50 AND state_region = 'Delhi'