| SELECT |
'Berkeley' as institution, count(pmid) as num_of_publications |
| FROM |
medline_citation |
| WHERE |
CONTAINS(article_affiliation,'"Berkeley"') = 1 |
| AND |
date_created > current date – 3 years |
| UNION |
|
| SELECT |
'Stanford' as institution, count(pmid) as num_of_publications |
| FROM |
medline_citation |
| WHERE |
CONTAINS(article_affiliation,'"Stanford"') = 1 |
| AND |
date_created > current date – 3 years; |
Oliver et al. BMC Bioinformatics 2004 5:146 doi:10.1186/1471-2105-5-146 |
|