use or in query condition in sql server

Which query will you use to achieve the objective?