Question: what is the difference between static and dynamic query?
Answer: A dynamic query is updated with its criteria each time you click into the query. ... A static query is a result that never changes. It is based on information that matched the criteria from the particular moment when the query was made.