{
  "facility_sql": "SELECT\r\n\t/*FACILITY_TAG*/\r\n\tGUID AS customer_guid,\r\n                     FIRSTNAME,\r\n\tLASTNAME,\r\n                     BDAY,\r\n                    1 AS present\r\nFROM\r\ncustomers c\r\nwhere c.ARCHIVED = 0",
  "merge_sql": "SELECT\r\n\t_cgr.FIRSTNAME,\r\n\t_cgr.LASTNAME,\r\n                     _cgr.BDAY,\r\n\tSUM(_cgr.present) AS present\r\n    /*EXP1*/\r\nFROM\r\n\t_cgr\r\n    /*FACILITY_TABLE_JOINS*/\r\nGROUP BY\r\n\t_cgr.FIRSTNAME,\r\n\t_cgr.LASTNAME,\r\n                     _cgr.BDAY\r\nHAVING COUNT(DISTINCT _cgr.customer_guid) > 1",
  "json": "{\r\n  \"facility_column_tag\": \"/*FACILITY_TAG*/\",\r\n  \"facility_tables_join_on\": \"customer_guid\",\r\n  \"facility_tables_join_tag\": \"/*FACILITY_TABLE_JOINS*/\",\r\n  \"merge_table_replacements\": [\r\n    {\r\n      \"tag\": \"/*EXP1*/\",\r\n      \"body\": \"sum({TABLE}.present) As {FACILITY}_present\",\r\n      \"prefix\": \",\",\r\n      \"glue\": \",\"\r\n    }\r\n  ]\r\n}",
  "name": "Duplicate Customers"
}