Practice · Economy · Hard

The Hepatitis C collapse, in percent

Using the two "Hepatitis C prevalence" rows (2016 and 2023), return the percentage fall from 2016 to 2023 as pct_drop, rounded to 1 decimal.

Solve this challenge →

Runs in your browser. No signup needed.

What you are given

Use indicators (name = 'Hepatitis C prevalence'). Pull each year with a scalar subquery.

Starting point

SELECT ROUND(
  ((SELECT value FROM indicators WHERE name='Hepatitis C prevalence' AND year=2016)
 - (SELECT value FROM indicators WHERE name='Hepatitis C prevalence' AND year=2023))
 / (SELECT value FROM indicators WHERE name='Hepatitis C prevalence' AND year=2016) * 100, 1) AS pct_drop;

The reference solution is checked automatically when you run your query on the practice page — results are compared row by row.

Did you know

Prevalence fell from ~10% to 0.38% — a ~96% drop — earning Egypt the world’s first WHO “gold tier” on the path to eliminating hepatitis C (2023). (WHO)

More Economy challenges

Big export earners Easy
GDP, year by year Medium
Year-over-year GDP change (window function) Hard
Total value of top exports Easy
The high-inflation years Medium

Open it in the playground →