gistfile1.sql

select p.id as publication, count(distinct a.id) as authors, i.country, p.year
from affiliated_author as a
join publication as p on p.id = a.publication_id
join institution as i on i.id = a.institution_id
where a.publication_id in (
	-- Publications with any author from Kuwait published on or before 2005
	select distinct p.id
	from publication as p
	join affiliated_author as a on a.publication_id = p.id
	join institution as i on a.institution_id = i.id
	where i.country = 'Kuwait' and p.year <= 2005
)
group by i.country, p.id, p.year
order by p.year;