I’m not sure about that unless when you say “All component attended” you mean all components that was related to the particular fire safety drill was attended? Otherwise we cannot assume that someone will attend every single fire safety Drill in the future.
I tried the new sql and unfortunately I am not getting the result that I am looking for; basically returning attended components.
What I am looking for is to show a list of components that exists and have still not been attended by the user.