SELECT DISTINCT year, APPROX_QUANTILES(altmetric_score, 100 IGNORE NULLS)[OFFSET(50)] AS median_score
FROM `altmetric.data_restricted_internal.research_outputs`
WHERE internal_qa.output_type = "article"
SELECT DISTINCT year, APPROX_QUANTILES(altmetric_score, 100 IGNORE NULLS)[OFFSET(50)] AS median_score
FROM `altmetric.data_restricted_internal.research_outputs`
WHERE internal_qa.output_type = "article"
FROM `dimensions-ai.data_analytics.publications`
WHERE type = "article"
GROUP BY 1
ORDER BY year DESC
FROM `dimensions-ai.data_analytics.publications`
WHERE type = "article"
GROUP BY 1
ORDER BY year DESC