Define an optimised set of queries for a database

Given the open database define a set of queries. Each query has to be optimized using e.g. joins, Indexes (B-trees, Hash tables, Bitmap indexes, join indexes), Materialized views, Clusters, Fragmentation, grouping, sampling with explanations.

Database: https://www.kaggle.com/datasets/hgultekin/eu-research-projects?select=cordis-h2020projects.csv