backfill/2025-01-22-firefox-installer schema-error/null_field_ratio.sql [79:147]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  COUNT(_64bit_build) / COUNT(*) AS _64bit_build_non_null_ratio,
  COUNT(_64bit_os) / COUNT(*) AS _64bit_os_non_null_ratio,
  COUNT(admin_user) / COUNT(*) AS admin_user_non_null_ratio,
  COUNT(attribution) / COUNT(*) AS attribution_non_null_ratio,
  COUNT(build_channel) / COUNT(*) AS build_channel_non_null_ratio,
  COUNT(build_id) / COUNT(*) AS build_id_non_null_ratio,
  COUNT(bytes_downloaded) / COUNT(*) AS bytes_downloaded_non_null_ratio,
  COUNT(default_path) / COUNT(*) AS default_path_non_null_ratio,
  COUNT(disk_space_error) / COUNT(*) AS disk_space_error_non_null_ratio,
  COUNT(disk_space_req_not_met) / COUNT(*) AS disk_space_req_not_met_non_null_ratio,
  COUNT(distribution_id) / COUNT(*) AS distribution_id_non_null_ratio,
  COUNT(distribution_version) / COUNT(*) AS distribution_version_non_null_ratio,
  COUNT(document_id) / COUNT(*) AS document_id_non_null_ratio,
  COUNT(download_ip) / COUNT(*) AS download_ip_non_null_ratio,
  COUNT(download_latency) / COUNT(*) AS download_latency_non_null_ratio,
  COUNT(download_retries) / COUNT(*) AS download_retries_non_null_ratio,
  COUNT(download_size) / COUNT(*) AS download_size_non_null_ratio,
  COUNT(download_time) / COUNT(*) AS download_time_non_null_ratio,
  COUNT(file_error) / COUNT(*) AS file_error_non_null_ratio,
  COUNT(finish_time) / COUNT(*) AS finish_time_non_null_ratio,
  COUNT(from_msi) / COUNT(*) AS from_msi_non_null_ratio,
  COUNT(funnelcake) / COUNT(*) AS funnelcake_non_null_ratio,
  COUNT(had_old_install) / COUNT(*) AS had_old_install_non_null_ratio,
  COUNT(hardware_req_not_met) / COUNT(*) AS hardware_req_not_met_non_null_ratio,
  COUNT(install_time) / COUNT(*) AS install_time_non_null_ratio,
  COUNT(install_timeout) / COUNT(*) AS install_timeout_non_null_ratio,
  COUNT(installer_type) / COUNT(*) AS installer_type_non_null_ratio,
  COUNT(installer_version) / COUNT(*) AS installer_version_non_null_ratio,
  COUNT(intro_time) / COUNT(*) AS intro_time_non_null_ratio,
  COUNT(locale) / COUNT(*) AS locale_non_null_ratio,
  COUNT(manual_download) / COUNT(*) AS manual_download_non_null_ratio,
  COUNT(new_default) / COUNT(*) AS new_default_non_null_ratio,
  COUNT(new_launched) / COUNT(*) AS new_launched_non_null_ratio,
  COUNT(no_write_access) / COUNT(*) AS no_write_access_non_null_ratio,
  COUNT(normalized_app_name) / COUNT(*) AS normalized_app_name_non_null_ratio,
  COUNT(normalized_channel) / COUNT(*) AS normalized_channel_non_null_ratio,
  COUNT(normalized_country_code) / COUNT(*) AS normalized_country_code_non_null_ratio,
  COUNT(normalized_os) / COUNT(*) AS normalized_os_non_null_ratio,
  COUNT(normalized_os_version) / COUNT(*) AS normalized_os_version_non_null_ratio,
  COUNT(old_build_id) / COUNT(*) AS old_build_id_non_null_ratio,
  COUNT(old_default) / COUNT(*) AS old_default_non_null_ratio,
  COUNT(old_running) / COUNT(*) AS old_running_non_null_ratio,
  COUNT(old_version) / COUNT(*) AS old_version_non_null_ratio,
  COUNT(options_time) / COUNT(*) AS options_time_non_null_ratio,
  COUNT(os_version) / COUNT(*) AS os_version_non_null_ratio,
  COUNT(os_version_req_not_met) / COUNT(*) AS os_version_req_not_met_non_null_ratio,
  COUNT(out_of_retries) / COUNT(*) AS out_of_retries_non_null_ratio,
  COUNT(ping_version) / COUNT(*) AS ping_version_non_null_ratio,
  COUNT(preinstall_time) / COUNT(*) AS preinstall_time_non_null_ratio,
  COUNT(profile_cleanup_prompt) / COUNT(*) AS profile_cleanup_prompt_non_null_ratio,
  COUNT(profile_cleanup_requested) / COUNT(*) AS profile_cleanup_requested_non_null_ratio,
  COUNT(sample_id) / COUNT(*) AS sample_id_non_null_ratio,
  COUNT(server_os) / COUNT(*) AS server_os_non_null_ratio,
  COUNT(service_pack) / COUNT(*) AS service_pack_non_null_ratio,
  COUNT(set_default) / COUNT(*) AS set_default_non_null_ratio,
  COUNT(sig_check_timeout) / COUNT(*) AS sig_check_timeout_non_null_ratio,
  COUNT(sig_not_trusted) / COUNT(*) AS sig_not_trusted_non_null_ratio,
  COUNT(sig_unexpected) / COUNT(*) AS sig_unexpected_non_null_ratio,
  COUNT(silent) / COUNT(*) AS silent_non_null_ratio,
  COUNT(stub_build_id) / COUNT(*) AS stub_build_id_non_null_ratio,
  COUNT(submission_timestamp) / COUNT(*) AS submission_timestamp_non_null_ratio,
  COUNT(succeeded) / COUNT(*) AS succeeded_non_null_ratio,
  COUNT(unknown_error) / COUNT(*) AS unknown_error_non_null_ratio,
  COUNT(update_channel) / COUNT(*) AS update_channel_non_null_ratio,
  COUNT(user_cancelled) / COUNT(*) AS user_cancelled_non_null_ratio,
  COUNT(version) / COUNT(*) AS version_non_null_ratio,
  COUNT(windows_ubr) / COUNT(*) AS windows_ubr_non_null_ratio,
  COUNT(writeable_req_not_met) / COUNT(*) AS writeable_req_not_met_non_null_ratio,
FROM
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



backfill/2025-01-22-firefox-installer schema-error/null_field_ratio.sql [162:230]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
  COUNT(_64bit_build) / COUNT(*) AS _64bit_build_non_null_ratio,
  COUNT(_64bit_os) / COUNT(*) AS _64bit_os_non_null_ratio,
  COUNT(admin_user) / COUNT(*) AS admin_user_non_null_ratio,
  COUNT(attribution) / COUNT(*) AS attribution_non_null_ratio,
  COUNT(build_channel) / COUNT(*) AS build_channel_non_null_ratio,
  COUNT(build_id) / COUNT(*) AS build_id_non_null_ratio,
  COUNT(bytes_downloaded) / COUNT(*) AS bytes_downloaded_non_null_ratio,
  COUNT(default_path) / COUNT(*) AS default_path_non_null_ratio,
  COUNT(disk_space_error) / COUNT(*) AS disk_space_error_non_null_ratio,
  COUNT(disk_space_req_not_met) / COUNT(*) AS disk_space_req_not_met_non_null_ratio,
  COUNT(distribution_id) / COUNT(*) AS distribution_id_non_null_ratio,
  COUNT(distribution_version) / COUNT(*) AS distribution_version_non_null_ratio,
  COUNT(document_id) / COUNT(*) AS document_id_non_null_ratio,
  COUNT(download_ip) / COUNT(*) AS download_ip_non_null_ratio,
  COUNT(download_latency) / COUNT(*) AS download_latency_non_null_ratio,
  COUNT(download_retries) / COUNT(*) AS download_retries_non_null_ratio,
  COUNT(download_size) / COUNT(*) AS download_size_non_null_ratio,
  COUNT(download_time) / COUNT(*) AS download_time_non_null_ratio,
  COUNT(file_error) / COUNT(*) AS file_error_non_null_ratio,
  COUNT(finish_time) / COUNT(*) AS finish_time_non_null_ratio,
  COUNT(from_msi) / COUNT(*) AS from_msi_non_null_ratio,
  COUNT(funnelcake) / COUNT(*) AS funnelcake_non_null_ratio,
  COUNT(had_old_install) / COUNT(*) AS had_old_install_non_null_ratio,
  COUNT(hardware_req_not_met) / COUNT(*) AS hardware_req_not_met_non_null_ratio,
  COUNT(install_time) / COUNT(*) AS install_time_non_null_ratio,
  COUNT(install_timeout) / COUNT(*) AS install_timeout_non_null_ratio,
  COUNT(installer_type) / COUNT(*) AS installer_type_non_null_ratio,
  COUNT(installer_version) / COUNT(*) AS installer_version_non_null_ratio,
  COUNT(intro_time) / COUNT(*) AS intro_time_non_null_ratio,
  COUNT(locale) / COUNT(*) AS locale_non_null_ratio,
  COUNT(manual_download) / COUNT(*) AS manual_download_non_null_ratio,
  COUNT(new_default) / COUNT(*) AS new_default_non_null_ratio,
  COUNT(new_launched) / COUNT(*) AS new_launched_non_null_ratio,
  COUNT(no_write_access) / COUNT(*) AS no_write_access_non_null_ratio,
  COUNT(normalized_app_name) / COUNT(*) AS normalized_app_name_non_null_ratio,
  COUNT(normalized_channel) / COUNT(*) AS normalized_channel_non_null_ratio,
  COUNT(normalized_country_code) / COUNT(*) AS normalized_country_code_non_null_ratio,
  COUNT(normalized_os) / COUNT(*) AS normalized_os_non_null_ratio,
  COUNT(normalized_os_version) / COUNT(*) AS normalized_os_version_non_null_ratio,
  COUNT(old_build_id) / COUNT(*) AS old_build_id_non_null_ratio,
  COUNT(old_default) / COUNT(*) AS old_default_non_null_ratio,
  COUNT(old_running) / COUNT(*) AS old_running_non_null_ratio,
  COUNT(old_version) / COUNT(*) AS old_version_non_null_ratio,
  COUNT(options_time) / COUNT(*) AS options_time_non_null_ratio,
  COUNT(os_version) / COUNT(*) AS os_version_non_null_ratio,
  COUNT(os_version_req_not_met) / COUNT(*) AS os_version_req_not_met_non_null_ratio,
  COUNT(out_of_retries) / COUNT(*) AS out_of_retries_non_null_ratio,
  COUNT(ping_version) / COUNT(*) AS ping_version_non_null_ratio,
  COUNT(preinstall_time) / COUNT(*) AS preinstall_time_non_null_ratio,
  COUNT(profile_cleanup_prompt) / COUNT(*) AS profile_cleanup_prompt_non_null_ratio,
  COUNT(profile_cleanup_requested) / COUNT(*) AS profile_cleanup_requested_non_null_ratio,
  COUNT(sample_id) / COUNT(*) AS sample_id_non_null_ratio,
  COUNT(server_os) / COUNT(*) AS server_os_non_null_ratio,
  COUNT(service_pack) / COUNT(*) AS service_pack_non_null_ratio,
  COUNT(set_default) / COUNT(*) AS set_default_non_null_ratio,
  COUNT(sig_check_timeout) / COUNT(*) AS sig_check_timeout_non_null_ratio,
  COUNT(sig_not_trusted) / COUNT(*) AS sig_not_trusted_non_null_ratio,
  COUNT(sig_unexpected) / COUNT(*) AS sig_unexpected_non_null_ratio,
  COUNT(silent) / COUNT(*) AS silent_non_null_ratio,
  COUNT(stub_build_id) / COUNT(*) AS stub_build_id_non_null_ratio,
  COUNT(submission_timestamp) / COUNT(*) AS submission_timestamp_non_null_ratio,
  COUNT(succeeded) / COUNT(*) AS succeeded_non_null_ratio,
  COUNT(unknown_error) / COUNT(*) AS unknown_error_non_null_ratio,
  COUNT(update_channel) / COUNT(*) AS update_channel_non_null_ratio,
  COUNT(user_cancelled) / COUNT(*) AS user_cancelled_non_null_ratio,
  COUNT(version) / COUNT(*) AS version_non_null_ratio,
  COUNT(windows_ubr) / COUNT(*) AS windows_ubr_non_null_ratio,
  COUNT(writeable_req_not_met) / COUNT(*) AS writeable_req_not_met_non_null_ratio,
FROM
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



