从SQL Server中选择具有匹配列的行

I am fairly certain that this is something simple, but every example I have tried is failing. I want to query a table like thisI am fairly certain that this is something simp