I am PhD student at KU Leuven (Belgium) and I am currently searching the TOP 150 applicants with the EPO and the USPTO in the following sectors combined: "HOSPITAL", "NON-PROFIT", "GOV", "UNIVERSITY".
I have formulated my query as follows:
Code: Select all
SELECT TOP 150 COUNT(*) AS NumberOfApplications, doc_std_name, psn_sector
FROM tls206_person p
JOIN tls207_pers_appln pa ON p.person_id = pa.person_id
JOIN tls201_appln a ON pa.appln_id = a.appln_id
WHERE psn_sector = 'UNIVERSITY' OR psn_sector='GOV' OR psn_sector='HOSPITAL' OR psn_sector='NON-PROFIT'
AND appln_auth= 'EP' OR appln_auth = 'US'
AND pa.applt_seq_nr > 0
AND GRANTED = 'Y'
AND appln_filing_year between 2000 and 2020
AND appln_kind = 'A'
AND docdb_family_size>2
AND a.appln_id < 900000000
GROUP BY doc_std_name, person_ctry_code, psn_sector
ORDER BY NumberOfApplications DESC
Would it be possible to assist me with this matter?
I thank you very much and I wish you a very nice day!
Kind regards,
Diana Maria Lica