We can use below query with OR Logical operator to return all rows where FName='Raza' Or CountryShortName='US'.

Select * From dbo.Customer
where FName='Raza'OR CountryShortName='US'

As we have used OR logical operator in our query, the row will be returned if at-least one condition is true. We can see that for FName='Raza', the row is selected even second condition is not true.
Same goes for other three records which are returned even FName is not equal to 'Raza' but CountryShortName is equal to 'US' that makes one condition true.