I like alive awesome people

SELECT *
FROM [Universe].[dbo].[Earth] (NOLOCK)
WHERE Human = 'Awesome'
AND VitalSigns > 0