create_table_act_with_trans_sqlite.sql

create table act_with_trans as
select *
from act_repaired_dates a
    join aid_trans_counts atc on a.fk_aid = atc.fk_aid;