Skip to main content

Table 9 Table 9

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;