<commit_before>SELECT af.row_number, af.fain, af.uri
FROM award_financial AS af
WHERE af.submission_id = {0}
    AND NOT EXISTS (
        SELECT cgac_code
        FROM cgac
        WHERE cgac_code = af.allocation_transfer_agency
     )
	AND af.row_number NOT IN (
		SELECT af.row_number
		FROM award_financial AS af
			JOIN award_financial_assistance AS afa
				ON (af.fain IS NOT DISTINCT FROM afa.fain
				AND af.uri IS NOT DISTINCT FROM afa.uri
				AND af.submission_id = afa.submission_id)
		WHERE af.submission_id = {0}
	);<commit_msg>Updating C8 based on feedback from Schema team<commit_after>SELECT DISTINCT af.row_number, af.fain, af.uri
FROM award_financial AS af
	JOIN award_financial_assistance AS afa
		ON (af.submission_id = afa.submission_id
			AND (
				af.fain IS DISTINCT FROM afa.fain
				OR af.uri IS DISTINCT FROM afa.uri
			)
		)
WHERE af.submission_id = {0}
	AND NOT EXISTS (
        SELECT cgac_code
        FROM cgac
        WHERE cgac_code = af.allocation_transfer_agency
	);
{'fraction_non_alphanumeric': 0.061938061938061936, 'fraction_numerical': 0.003996003996003996, 'mean_word_length': 3.1065573770491803, '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': '5996757', 'n_tokens_mistral': 405, 'n_tokens_neox': 364, 'n_words': 103}