         ("awc_location_months"."district_id" = "agg_child_health"."district_id") AND
         ("awc_location_months"."block_id" = "agg_child_health"."block_id") AND
         ("awc_location_months"."supervisor_id" = "agg_child_health"."supervisor_id") AND
-        ("awc_location_months"."awc_id" = "agg_child_health"."awc_id") AND
-        ("child_health_categories"."gender" = "agg_child_health"."gender") AND
-        ("child_health_categories"."age_tranche" = "agg_child_health"."age_tranche") AND
-        ("child_health_categories"."caste" = "agg_child_health"."caste") AND
-        ("child_health_categories"."disabled" = "agg_child_health"."disabled") AND
-        ("child_health_categories"."minority" = "agg_child_health"."minority") AND
-        ("child_health_categories"."resident" = "agg_child_health"."resident")
+        ("awc_location_months"."awc_id" = "agg_child_health"."awc_id")
     );
 
 DROP VIEW IF EXISTS agg_thr_monthly CASCADE;

        ("awc_location_months"."district_id" = "agg_ccs_record"."district_id") AND
        ("awc_location_months"."block_id" = "agg_ccs_record"."block_id") AND
        ("awc_location_months"."supervisor_id" = "agg_ccs_record"."supervisor_id") AND
        ("awc_location_months"."awc_id" = "agg_ccs_record"."awc_id") AND
        ("ccs_record_categories"."ccs_status" = "agg_ccs_record"."ccs_status") AND
        ("ccs_record_categories"."trimester" = "agg_ccs_record"."trimester") AND
        ("ccs_record_categories"."caste" = "agg_ccs_record"."caste") AND
        ("ccs_record_categories"."disabled" = "agg_ccs_record"."disabled") AND
        ("ccs_record_categories"."minority" = "agg_ccs_record"."minority") AND
        ("ccs_record_categories"."resident" = "agg_ccs_record"."resident")
    );

DROP VIEW IF EXISTS agg_child_health_monthly CASCADE;

        "awc_location_months"."aggregation_level" AS "aggregation_level",
        "awc_location_months"."month" AS "month",
        "awc_location_months"."month_display" AS "month_display",
        "agg_child_health"."gender" AS "gender",
        "agg_child_health"."age_tranche" AS "age_tranche",
        "agg_child_health"."caste" AS "caste",
        "agg_child_health"."disabled" AS "disabled",
        "agg_child_health"."minority" AS "minority",
        "agg_child_health"."resident" AS "resident",
        COALESCE("agg_child_health"."valid_in_month", 0) AS "valid_in_month",
        COALESCE("agg_child_health"."valid_all_registered_in_month", 0) AS "valid_all_registered_in_month",
        COALESCE("agg_child_health"."nutrition_status_weighed", 0) AS "nutrition_status_weighed",
