Microsoft Academic Graph: Patents vs Language

patentlanguage.sql

// modify the following two values as needed
DECLARE @dataVersion string = "mag-YYYY-MM-DD";
DECLARE @blobAccount string = "XXX";

DECLARE @uriPrefix   string = "wasb://" + @dataVersion + "@" + @blobAccount + "/";
DECLARE @outFile string = "/Output/patent_languages.tsv";

@Papers = Papers(@uriPrefix);
@PaperLanguages = PaperLanguages(@uriPrefix);


@plCounts = SELECT
    L.LanguageCode, COUNT(1) AS cnt
FROM
    @PaperLanguages AS L
INNER JOIN
    @Papers AS P
ON
    P.PaperId == L.PaperId
WHERE
    DocType == "Patent" 
GROUP BY
    L.LanguageCode;


OUTPUT @plCounts TO @outFile
USING Outputters.Tsv(quoting : false);