Advertisement
Guest User

Untitled

a guest
Mar 5th, 2015
206
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. select year,AuthorID,count(*) as count from Publications natural join Authors natural join Publish group by AuthorID,year having count(*) = (select count(*) from Publications natural join Authors natural join Publish group by AuthorID,year order by count(*) limit 1) ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement