Thanks for taking the time to help me, I appreciate it.
So if I were to create a calculation summary table, I would probably need a trigger to update it from the source table right?
Can you please offer some suggestions on how I can write this trigger based on the query I provided? Because I have the count, group by and joins the trigger syntax is not clear for me based on the simple examples I found online. I am using a MySQL DB.