FROM sonicwall-coverage
| WHERE scope_id=="sonicwall-20261107-v6"
| STATS raw_records=SUM(raw_records),raw_expected_records=SUM(raw_expected_records),targeted_messages=SUM(targeted_messages),excluded_records=SUM(excluded_records),unrecognized_records=SUM(unrecognized_records),normalized_matches=SUM(normalized_matches),timestamp_gaps=SUM(timestamp_gaps),mapping_gaps=SUM(mapping_gaps),manifest_gaps=SUM(manifest_gaps),binding_not_applicable=SUM(binding_not_applicable),h1_gap=SUM(h1_gap),h2_gap=SUM(h2_gap),h3_gap=SUM(h3_gap),h4_gap=SUM(h4_gap) BY snapshot_id,coverage_source
| LIMIT 10000
