Dear community, I am conducting an empirical research on innovation and I would like the following data: Company (I am using ISIN code) Nr of Patents per year Forward Citations per year for the time horizon 2010-2018 Currently I am facing difficulties in retrieving the query, as a beginner in sql. S...

Hello,

I am interested in a query which presents firms with ISIN code, the nr of patents per year (2010-2018) and the nr of legal case for patents issues opened.
Is it possible to construct it?
Thank you!