When the following SQL statement is executed

Select Name

From Rider join Horse on Rider.HorseID $=$ Horse.HorseID

Question $30$ options:

It will work if only one table has the Name attribute

It might not work if Rider and Horse both have Name attributes

It will return the Name value from both tables if both tables have Name in them

Both a and b are correct