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%';
substance_idname
42325700COVID-19 MRNA VACCINE PFIZER-BIONTECH (TOZINAMERAN)
60123556COVID-19 MRNA VACCINE PFIZER-BIONTECH ORIGINAL/OMICRON BA.1 (TOZINAMERAN, RILTOZINAMERAN)
60141237COVID-19 MRNA VACCINE PFIZER-BIONTECH ORIGINAL/OMICRON BA.4-5 (TOZINAMERAN, FAMTOZINAMERAN)

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;
reactionoutcomecount
COVID-1998917
Vaccination failure88821
HeadacheRecovered/Resolved71871
PyrexiaRecovered/Resolved69366
FatigueNot Recovered/Not Resolved49876
HeadacheNot Recovered/Not Resolved49474
FatigueRecovered/Resolved47029
MyalgiaRecovered/Resolved43603
ChillsRecovered/Resolved40605
HeadacheRecovering/Resolving34880

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