<commit_before>#Show the location of each mutation
SELECT
      reference_name,
      start,
      reference_bases,
      alternate_bases
    FROM
      [genomics-public-data:platinum_genomes.variants]
    WHERE
      reference_name = 'chr17'
      AND start BETWEEN 41196311
      AND 41277499     
      AND LENGTH(alternate_bases) == 1
      AND LENGTH(reference_bases) == 1
    GROUP BY
      reference_name,
      start,
      end,
      reference_bases,
      alternate_bases
    ORDER BY
      start<commit_msg>Minor changes to query.<commit_after># Show the location of each SNP.
SELECT
      reference_name,
      start,
      reference_bases,
      alternate_bases
    FROM
      [_THE_TABLE_]
    WHERE
      reference_name = 'chr17'
      AND start BETWEEN 41196311
      AND 41277499     
      AND LENGTH(alternate_bases) == 1
      AND LENGTH(reference_bases) == 1
    GROUP BY
      reference_name,
      start,
      end,
      reference_bases,
      alternate_bases
    ORDER BY
      start
      
{'fraction_non_alphanumeric': 0.053201970443349754, 'fraction_numerical': 0.03940886699507389, 'mean_word_length': 2.069486404833837, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5925802', 'n_tokens_mistral': 357, 'n_tokens_neox': 318, 'n_words': 79}