Top 10 reactions for Tozinameran

The number one substance we found earlier was Tozinameran. To find the top 10 reactions with their outcome for the Tozinameran substance, we first lookup the substance_id:

SELECT 
  *
from import.substances
where name ilike '%TOZINAMERAN%';

Let's select substance_id 42325700 and see in the reaction table for substances which reactions are related to this substance_id, we will group them by reaction and outcome to get an general idea and limit the result to 10.

select
  reaction,
  outcome,
  count(*)
from
  import.substance_reaction
where substance_id = 42325700
GROUP BY substance_id, reaction, outcome
order by count(*) desc limit 10;

In 98917 reports, the reaction was COVID-19. In 88821cases the vaccination failed.