Help with SQL query - How to count the number of patent applications of a specific company
Posted: Mon Nov 09, 2020 12:24 pm
Hi everyone,
I am currently working with PATSTAT Spring 2020 edition. I am currently looking at the number of total granted patents of a specific company from 2000 to 2019.
I also would like to add the results as a column next to my existing table if possible:
I am not sure how to obtain the results since PATSTAT is quite new to me.
Any advice is much appreciated. Many thanks in advance.
I am currently working with PATSTAT Spring 2020 edition. I am currently looking at the number of total granted patents of a specific company from 2000 to 2019.
I also would like to add the results as a column next to my existing table if possible:
Code: Select all
SELECT t1.appln_id, t1.appln_auth, t1.appln_filing_date, t2.ipc_class_symbol, t3.appln_title
FROM
tls201_appln t1
JOIN
tls209_appln_ipc t2 ON t1.appln_id = t2.appln_id
JOIN
tls202_appln_title t3 ON t3.appln_id = t1.appln_id
WHERE
t2.ipc_class_symbol LIKE 'C12N%'
AND t1.appln_auth IN ('GB')
AND t1.appln_filing_date between '2016-01-01' and '2020-01-01'
Any advice is much appreciated. Many thanks in advance.