text: SELECT "Taxpayer_1"."nppes_provider_first_name" AS "nppes_provider_first_name" FROM "Taxpayer_1" WHERE (("Taxpayer_1"."nppes_provider_last_org_name" = 'HOLDER') AND ("Taxpayer_1"."nppes_provider_state" = 'WA')) GROUP BY 1
  SELECT "Taxpayer_10"."nppes_provider_city" AS "nppes_provider_city" FROM "Taxpayer_10" GROUP BY 1 ORDER BY "nppes_provider_city" ASC 
  SELECT "Taxpayer_10"."nppes_provider_city" AS "nppes_provider_city" FROM "Taxpayer_10" WHERE (("Taxpayer_10"."hcpcs_description" = 'Initial hospital care') AND ("Taxpayer_10"."nppes_provider_state" = 'WA')) GROUP BY 1
  SELECT "Taxpayer_10"."nppes_provider_city" AS "nppes_provider_city" FROM "Taxpayer_10" WHERE (("Taxpayer_10"."nppes_provider_first_name" = 'JOHN') AND ("Taxpayer_10"."nppes_provider_last_org_name" = 'HOLDER') AND ("Taxpayer_10"."nppes_provider_state" = 'WA')) GROUP BY 1
  SELECT "Taxpayer_10"."nppes_provider_city" AS "nppes_provider_city",   "Taxpayer_10"."nppes_provider_state" AS "nppes_provider_state" FROM "Taxpayer_10" WHERE (("Taxpayer_10"."nppes_provider_first_name" = 'JOHN') AND ("Taxpayer_10"."nppes_provider_last_org_name" = 'HOLDER')) GROUP BY 1,   2
  SELECT "Taxpayer_10"."nppes_provider_first_name" AS "nppes_provider_first_name" FROM "Taxpayer_10" WHERE (("Taxpayer_10"."nppes_provider_last_org_name" = 'HOLDER') AND ("Taxpayer_10"."nppes_provider_state" = 'WA')) GROUP BY 1
  SELECT "Taxpayer_10"."nppes_provider_street1" AS "nppes_provider_street1" FROM "Taxpayer_10" WHERE (("Taxpayer_10"."nppes_provider_first_name" = 'JOHN') AND ("Taxpayer_10"."nppes_provider_last_org_name" = 'HOLDER') AND ("Taxpayer_10"."nppes_provider_state" = 'WA')) GROUP BY 1
  SELECT "Taxpayer_2"."nppes_provider_last_org_name" AS "nppes_provider_last_org_name" FROM "Taxpayer_2" WHERE (("Taxpayer_2"."nppes_provider_first_name" = 'JOHN') AND ("Taxpayer_2"."nppes_provider_state" = 'WA')) GROUP BY 1
  SELECT "Taxpayer_3"."nppes_provider_state" AS "nppes_provider_state" FROM "Taxpayer_3" WHERE (("Taxpayer_3"."nppes_provider_first_name" = 'JOHN') AND ("Taxpayer_3"."nppes_provider_last_org_name" = 'HOLDER')) GROUP BY 1
  SELECT "Taxpayer_4"."nppes_provider_city" AS "nppes_provider_city" FROM "Taxpayer_4" WHERE (("Taxpayer_4"."nppes_provider_first_name" = 'JOHN') AND ("Taxpayer_4"."nppes_provider_last_org_name" = 'HOLDER') AND ("Taxpayer_4"."nppes_provider_state" = 'WA')) GROUP BY 1
  SELECT "Taxpayer_5"."nppes_provider_state" AS "nppes_provider_state" FROM "Taxpayer_5" WHERE (("Taxpayer_5"."nppes_provider_first_name" = 'JOHN') AND ("Taxpayer_5"."nppes_provider_last_org_name" = 'HOLDER')) GROUP BY 1
  SELECT "Taxpayer_6"."nppes_provider_city" AS "nppes_provider_city" FROM "Taxpayer_6" WHERE (("Taxpayer_6"."hcpcs_description" = 'Initial hospital care') AND ("Taxpayer_6"."nppes_provider_state" = 'WA')) GROUP BY 1
  SELECT "Taxpayer_7"."nppes_provider_last_org_name" AS "nppes_provider_last_org_name" FROM "Taxpayer_7" WHERE (("Taxpayer_7"."nppes_provider_first_name" = 'JOHN') AND ("Taxpayer_7"."nppes_provider_state" = 'WA')) GROUP BY 1
  SELECT "Taxpayer_9"."nppes_provider_street1" AS "nppes_provider_street1" FROM "Taxpayer_9" WHERE (("Taxpayer_9"."nppes_provider_first_name" = 'JOHN') AND ("Taxpayer_9"."nppes_provider_last_org_name" = 'HOLDER') AND ("Taxpayer_9"."nppes_provider_state" = 'WA')) GROUP BY 1
  SELECT AVG(CAST(("Taxpayer_10"."average_Medicare_allowed_amt" - "Taxpayer_10"."average_Medicare_payment_amt") AS double)) AS "avg:Calculation_9940518082838207:ok",   "Taxpayer_10"."nppes_provider_first_name" AS "nppes_provider_first_name" FROM "Taxpayer_10" WHERE (("Taxpayer_10"."hcpcs_description" = 'Initial hospital care') AND ("Taxpayer_10"."nppes_provider_city" IN ('BELLEVUE', 'BELLVUE')) AND ("Taxpayer_10"."nppes_provider_state" = 'WA')) GROUP BY 2
  SELECT AVG(CAST(("Taxpayer_10"."average_Medicare_allowed_amt" - "Taxpayer_10"."average_Medicare_payment_amt") AS double)) AS "avg:Calculation_9940518082838207:ok",   "Taxpayer_10"."nppes_provider_last_org_name" AS "nppes_provider_last_org_name" FROM "Taxpayer_10" WHERE (("Taxpayer_10"."hcpcs_description" = 'Initial hospital care') AND ("Taxpayer_10"."nppes_provider_city" IN ('BELLEVUE', 'BELLVUE')) AND ("Taxpayer_10"."nppes_provider_state" = 'WA')) GROUP BY 2
  SELECT AVG(CAST(("Taxpayer_10"."average_Medicare_allowed_amt" - "Taxpayer_10"."average_Medicare_payment_amt") AS double)) AS "avg:Calculation_9940518082838207:ok",   AVG(CAST("Taxpayer_10"."average_Medicare_allowed_amt" AS double)) AS "avg:average_Medicare_allowed_amt:ok",   AVG(CAST("Taxpayer_10"."average_Medicare_payment_amt" AS double)) AS "avg:average_Medicare_payment_amt:ok",   AVG(CAST("Taxpayer_10"."average_submitted_chrg_amt" AS double)) AS "avg:average_submitted_chrg_amt:ok",   "Taxpayer_10"."hcpcs_description" AS "hcpcs_description" FROM "Taxpayer_10" WHERE (("Taxpayer_10"."hcpcs_description" = 'Initial hospital care') AND ("Taxpayer_10"."nppes_provider_first_name" = 'JOHN') AND ("Taxpayer_10"."nppes_provider_last_org_name" = 'HOLDER') AND ("Taxpayer_10"."nppes_provider_state" = 'WA')) GROUP BY 5
  SELECT AVG(CAST(("Taxpayer_10"."average_Medicare_allowed_amt" - "Taxpayer_10"."average_Medicare_payment_amt") AS double)) AS "avg:Calculation_9940518082838207:ok",   AVG(CAST("Taxpayer_10"."average_Medicare_allowed_amt" AS double)) AS "avg:average_Medicare_allowed_amt:ok",   AVG(CAST("Taxpayer_10"."average_Medicare_payment_amt" AS double)) AS "avg:average_Medicare_payment_amt:ok",   AVG(CAST("Taxpayer_10"."average_submitted_chrg_amt" AS double)) AS "avg:average_submitted_chrg_amt:ok",   "Taxpayer_10"."hcpcs_description" AS "hcpcs_description" FROM "Taxpayer_10" WHERE (("Taxpayer_10"."nppes_provider_first_name" = 'JOHN') AND ("Taxpayer_10"."nppes_provider_last_org_name" = 'HOLDER') AND ("Taxpayer_10"."nppes_provider_state" = 'WA')) GROUP BY 5
  SELECT AVG(CAST(("Taxpayer_8"."average_Medicare_allowed_amt" - "Taxpayer_8"."average_Medicare_payment_amt") AS double)) AS "avg:Calculation_9940518082838207:ok",   AVG(CAST("Taxpayer_8"."average_Medicare_allowed_amt" AS double)) AS "avg:average_Medicare_allowed_amt:ok",   AVG(CAST("Taxpayer_8"."average_Medicare_payment_amt" AS double)) AS "avg:average_Medicare_payment_amt:ok",   AVG(CAST("Taxpayer_8"."average_submitted_chrg_amt" AS double)) AS "avg:average_submitted_chrg_amt:ok",   "Taxpayer_8"."hcpcs_description" AS "hcpcs_description" FROM "Taxpayer_8" WHERE (("Taxpayer_8"."nppes_provider_first_name" = 'JOHN') AND ("Taxpayer_8"."nppes_provider_last_org_name" = 'HOLDER') AND ("Taxpayer_8"."nppes_provider_state" = 'WA')) GROUP BY 5
  SELECT MIN("Taxpayer_10"."hcpcs_description") AS "TEMP(attr:hcpcs_description:nk)(2092202119)(0)",   MAX("Taxpayer_10"."hcpcs_description") AS "TEMP(attr:hcpcs_description:nk)(3741561916)(0)",   AVG(CAST(("Taxpayer_10"."average_Medicare_allowed_amt" - "Taxpayer_10"."average_Medicare_payment_amt") AS double)) AS "avg:Calculation_9940518082838207:ok",   CAST("Taxpayer_10"."npi" AS BIGINT) AS "npi",   "Taxpayer_10"."nppes_provider_street1" AS "nppes_provider_street1" FROM "Taxpayer_10" WHERE (("Taxpayer_10"."hcpcs_description" = 'Initial hospital care') AND ("Taxpayer_10"."nppes_provider_state" = 'WA')) GROUP BY "Taxpayer_10"."npi",   5,   4
  SELECT MIN("Taxpayer_10"."nppes_provider_city") AS "TEMP(attr:nppes_provider_city:nk)(1982288585)(0)",   MIN("Taxpayer_10"."nppes_provider_city") AS "TEMP(attr:nppes_provider_city:nk)(3553589364)(0)",   MIN("Taxpayer_10"."nppes_provider_state") AS "TEMP(attr:nppes_provider_state:nk)(2565367484)(0)",   MIN("Taxpayer_10"."nppes_provider_state") AS "TEMP(attr:nppes_provider_state:nk)(792957481)(0)",   MAX("Taxpayer_10"."nppes_provider_street1") AS "TEMP(attr:nppes_provider_street1:nk)(1224842885)(0)",   MIN("Taxpayer_10"."nppes_provider_street1") AS "TEMP(attr:nppes_provider_street1:nk)(1567360354)(0)",   CAST(MIN("Taxpayer_10"."nppes_provider_zip") AS BIGINT) AS "TEMP(attr:nppes_provider_zip:qk)(1018202325)(0)",   CAST(MAX("Taxpayer_10"."nppes_provider_zip") AS BIGINT) AS "TEMP(attr:nppes_provider_zip:qk)(1223776409)(0)",   AVG(CAST(("Taxpayer_10"."average_Medicare_allowed_amt" - "Taxpayer_10"."average_Medicare_payment_amt") AS double)) AS "avg:Calculation_9940518082838207:ok",   AVG(CAST("Taxpayer_10"."average_Medicare_allowed_amt" AS double)) AS "avg:average_Medicare_allowed_amt:ok",   AVG(CAST("Taxpayer_10"."average_Medicare_payment_amt" AS double)) AS "avg:average_Medicare_payment_amt:ok",   AVG(CAST("Taxpayer_10"."average_submitted_chrg_amt" AS double)) AS "avg:average_submitted_chrg_amt:ok",   "Taxpayer_10"."nppes_provider_city" AS "nppes_provider_city",   "Taxpayer_10"."nppes_provider_first_name" AS "nppes_provider_first_name",   "Taxpayer_10"."nppes_provider_last_org_name" AS "nppes_provider_last_org_name",   "Taxpayer_10"."nppes_provider_state" AS "nppes_provider_state" FROM "Taxpayer_10" WHERE (("Taxpayer_10"."nppes_provider_city" IN ('BELLEVUE', 'BELLVUE')) AND ("Taxpayer_10"."nppes_provider_state" = 'WA') AND ("Taxpayer_10"."hcpcs_description" = 'Initial hospital care')) GROUP BY 13,   14,   15,   16
  SELECT MIN("Taxpayer_7"."nppes_provider_city") AS "TEMP(attr:nppes_provider_city:nk)(1982288585)(0)",   MIN("Taxpayer_7"."nppes_provider_city") AS "TEMP(attr:nppes_provider_city:nk)(3553589364)(0)",   MIN("Taxpayer_7"."nppes_provider_state") AS "TEMP(attr:nppes_provider_state:nk)(2565367484)(0)",   MIN("Taxpayer_7"."nppes_provider_state") AS "TEMP(attr:nppes_provider_state:nk)(792957481)(0)",   MAX("Taxpayer_7"."nppes_provider_street1") AS "TEMP(attr:nppes_provider_street1:nk)(1224842885)(0)",   MIN("Taxpayer_7"."nppes_provider_street1") AS "TEMP(attr:nppes_provider_street1:nk)(1567360354)(0)",   CAST(MIN("Taxpayer_7"."nppes_provider_zip") AS BIGINT) AS "TEMP(attr:nppes_provider_zip:qk)(1018202325)(0)",   CAST(MAX("Taxpayer_7"."nppes_provider_zip") AS BIGINT) AS "TEMP(attr:nppes_provider_zip:qk)(1223776409)(0)",   AVG(CAST(("Taxpayer_7"."average_Medicare_allowed_amt" - "Taxpayer_7"."average_Medicare_payment_amt") AS double)) AS "avg:Calculation_9940518082838207:ok",   AVG(CAST("Taxpayer_7"."average_Medicare_allowed_amt" AS double)) AS "avg:average_Medicare_allowed_amt:ok",   AVG(CAST("Taxpayer_7"."average_Medicare_payment_amt" AS double)) AS "avg:average_Medicare_payment_amt:ok",   AVG(CAST("Taxpayer_7"."average_submitted_chrg_amt" AS double)) AS "avg:average_submitted_chrg_amt:ok",   "Taxpayer_7"."nppes_provider_city" AS "nppes_provider_city",   "Taxpayer_7"."nppes_provider_first_name" AS "nppes_provider_first_name",   "Taxpayer_7"."nppes_provider_last_org_name" AS "nppes_provider_last_org_name",   "Taxpayer_7"."nppes_provider_state" AS "nppes_provider_state" FROM "Taxpayer_7" WHERE (("Taxpayer_7"."nppes_provider_city" IN ('BELLEVUE', 'BELLVUE')) AND ("Taxpayer_7"."nppes_provider_state" = 'WA') AND ("Taxpayer_7"."hcpcs_description" = 'Initial hospital care')) GROUP BY 13,   14,   15,   16
  