In correct Login three times after that correct login will not accept the same day

You can do this logic in SQL query
 
if(check the username exists)
begin
   if(InvalidAttempts for that user is 3)
   begin
    return "You account is locked"
   end
  else
  begin
   if(check the password is correct, if it is incorrect)
   begin
      Increment the table column InvliadAttempt value..
      return "Invalid username or password"
   end
    else
    begin 
    return "Success"
    end
  end
end
else
begin
return "invalid username"
end

Please help.......