Hi,
How would I use the EPO's Y02 classes to search for the top 20 (GB) applicants between 2005-2020 in the wind energy classification (Y02E10/70) and the biofuel classification (Y02E50/10 and Y02E50/30)? I am using PATSTAT Autumn 2021 edition and am struggling to get the queries correct. Could you suggest a sample query that would allow me to do this?
Best,
Evelyn
Searching with climate-friendly Y02 classification
-
- Posts: 1
- Joined: Sun Dec 05, 2021 2:39 pm
-
- Posts: 440
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: Searching with climate-friendly Y02 classification
See this post: https://forums.epo.org/sql-queries-to- ... able-10588 , and adapt the classifications codes to what you need.
Be careful with spaces and characters when you write the CPC codes; there should allways be 8 digits before the "/" symbol. In most cases it means adding spaces on positions 5, 6 or 7.
Be careful with spaces and characters when you write the CPC codes; there should allways be 8 digits before the "/" symbol. In most cases it means adding spaces on positions 5, 6 or 7.
Code: Select all
SELECT distinct [cpc_class_symbol]
FROM [patstat2021b].[dbo].[tls224_appln_cpc]
where cpc_class_symbol like 'Y02E 10/7%'
or cpc_class_symbol like 'Y02E 50/1%'
or cpc_class_symbol like 'Y02E 50/3%'
order by cpc_class_symbol
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org
EPO - Vienna
patstat @ epo.org