Searching with climate-friendly Y02 classification

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

EvelynRing
Posts: 1
Joined: Sun Dec 05, 2021 2:39 pm

Searching with climate-friendly Y02 classification

Post by EvelynRing » Sun Dec 05, 2021 2:45 pm

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


EPO / PATSTAT Support
Posts: 425
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: Searching with climate-friendly Y02 classification

Post by EPO / PATSTAT Support » Tue Dec 07, 2021 12:40 am

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.

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


Post Reply