Q&A about the site for professionals in medical and allied health fields, students of those professions, related academics, and others with a sound understanding of medicine and healthcare-related sciences
-- Enter Query Title -- Enter Query Description SELECT userid FROM badges b inner join users u on b.userid = u.id where userid = 119477 and b.name in ('Civic Duty', 'Strunk & White', 'Deputy', 'Convention') or (b.name = 'Yearling' and b.date > '1/1/2011') GROUP BY b.userid HAVING count(b.id) = 5