 from
         transcoder_reports
 group by
+	test_id,
         customer_id,
         profile_id,
         file_checksum;
 
 create or replace view unique_transcoder_outcomes_per_profile as
 select
+	test_id,
         customer_id,
         profile_id,
         sum(case when outcome then 1 else 0 end) as successful_transcods,

insert into schema_information(schema_version, upgrading_soon, upgrading_currently)
values ('2008123000', false, false);



-- a lookup table of possible transcode outcomes
create table if not exists transcoder_failures (

        sum(case when (not outcome) and (failure_id is null) then 1 else 0 end) as failed_unexpectedly_transcods
from
        unique_transcoder_reports
group by test_id, customer_id, profile_id;

create or replace view unique_internal_success_rate_per_profile as
select
	test_id,
        customer_id,
        profile_id,
        successful_transcods + failed_transcods as number_of_transcods,
