Master query for generating a quiz question data

[S-Maciejewski]

Implement a single query for retreiving a quiz question data based on random set of metrics and countries

[S-Maciejewski]

Depending on the case (single indicator set / multiple indicator sets - for each country) the query should look like this:

select "Country Name", "Indicator Name", "Country Code", "Year", "Value" from "Data" where "Country Code" in ('POL', 'BEL') and "Indicator Code" in ('SP.POP.TOTL', 'SP.POP.GROW');

Or more generic select "Country Name", "Indicator Name", "Country Code", "Year", "Value" from "Data" where "Country Code" in ('${countries.join("','")}') and "Indicator Code" in ('${indicators.join("','")}') where indicators and countries are codes as string

[S-Maciejewski]

Implemented in Repository.ts