/* Extract the emojii reactions from the 'note_reaction' table */
/* Exclude any that are stored as a text string */
SELECT reaction, COUNT(reaction)

FROM note_reaction

WHERE reaction NOT LIKE '%@%'

GROUP BY reaction

ORDER by COUNT(reaction) DESC