-- run on Athena
select lower(to_hex(sha1)) as sha1, name
from content
join ctas_license_blobs on ctas_license_blobs.sha1_git = content.sha1_git
order by sha1;
