query

Select
Case When Exists
(
    Select Id
    From People
    Where First_Name = 'agi' And Last_Name = 'agi'
) Then 1
Else 0
End As ErrType;