Hello,
Thank you for the information. I have used the paper titled "An Introduction to the Patstat Database with Example Queries", retrieved from https://onlinelibrary.wiley.com/doi/ful ... 8462.12073

Hello, This is in continuation to my earlier query. There are a lot of patent applications where the inventor country is not found. I saw the following code in the PATSTAT manual. Will the problem of not finding inventor country be solved using fractional count? SELECT d.person_ctry_code, SUM(tot_in...

Hello, Thank you for your prompt response and help. If I use - WHERE left (b.cpc_class_symbol, 10) = 'Y02E 10/7' AND c.invt_seq_nr > 0 , will it allow me to select all the patent applications tagged with Y02E10/70-766 under the Y02E tag for wind energy? Also, can you please explain the function of S...

Hello, I am using the PATSTAT Online database 2019 Autumn edition. I want to extract patent data by linking the 4 tables - 201, 224, 207 and 206. I want to see country-wise patents related to wind energy filed for the time period 1999 - 2018 tagged using the Y02E scheme. I want information related a...