Re: [eclipse.org-eclipsecon-program-committee] Authors Report

[Oisin Hurley <oisin.hurley@xxxxxxxxx>]

Hi Scott,
Ok, got the query, it had ended up filed in the wrong mailbox - how do
I run this again? My memory is a bit mushy on the topic.

I assume we are talking about the query to find authors with more than
2 talks? (see below)

 --oh

SELECT sa.personID, count(*) num_accepted

FROM submission_authors sa

inner join submissions s on s.submission_id = sa.submission_id

where s.conference_id = 5

and tentative_status = 'tentative_accept'

and role = 'author'

group by personID

having count(*) > 2

order by num_accepted desc, personId;