Table 9

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

Open Data