Consider the database represented by the following ERD:

An entity relationship diagram with three sections: Corgi, Outcome, Race.

If my SELECT clause were...

SELECT Corgname, RaceTime, RaceName, Date

What would need to be in my WHERE clause to join the required tables? $($Assume the FROM clause includes, but does not join, the required tables.$)$

Group of answer choices

WHERE Corgi.CorgID $=$ Outcome.OutcomeID AND Outcome.OutcomeID $=$ Race.RaceID

WHERE Corgi.CorgiID $=$ Outcome.CorgiID AND Outcome.RaceID $=$ Race.RaceID

WHERE C$.$CorgID $=$ O$.$CorgID

WHERE Corgi.CorgiID $=$ Outcome.OutcomeID $=$ Race.RaceID