From: Tools for loading MEDLINE into a local relational database
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; |