You have been asked to develop a query for a veterinary practice that asks you to only display the results for an Animal$\_$Type of cat and dog who have an Age younger than $7.$ The office manager also wants you to include all other Animal$\_$Type who have not had an Office$\_$Visit$\_$Last$\_$Year $($this field will show "Yes" if there was a visit and $"$No$"$ if there was not a visit$).$ Which WHERE clause will provide what the office manager has requested?

Question $5$ options:

WHERE $($Animal$\_$Type $=$ "cat" or Animal$\_$Type $=$ "dog" and Age $<7)$ or Office$\_$Visit$\_$Last$\_$Year $="$No$"$

WHERE $(($Animal$\_$Type $=$ "cat" or Animal$\_$Type $=$ "dog"$)$ and Age $<7)$ or Office$\_$Visit$\_$Last$\_$Year $="$No$"$

WHERE Animal$\_$Type $=$ "cat" or Animal$\_$Type $=$ "dog" and Age $<7$ or Office$\_$Visit$\_$Last$\_$Year $="$No$"$

WHERE $($Animal$\_$Type $=$ "cat" and Animal$\_$Type $=$ "dog" and Age $<7)$ or Office$\_$Visit$\_$Last$\_$Year $="$No$"$