All Users
select * from `users`
idFirstNameLastName
1CoryLocklear
2ThomasHopkins
3NeverAttemptedLogin
4WayneDawson

Login Successes
select * from `loginSuccesses`
idusertimestamp
112015-04-11 13:07:11
222015-04-11 13:07:32

Login Successes
select * from `loginFailures`
idusertimestamp
112015-04-11 13:06:46
222015-04-11 13:07:40
342015-04-11 13:07:56
442015-04-11 13:08:03

Users who have never successfully logged in, using subselect
select * from users where id not in (select distinct user from loginSuccesses)
idFirstNameLastName
3NeverAttemptedLogin
4WayneDawson

Users who have never successfully logged in, using LEFT JOIN
select u.id, FirstName, LastName from users u LEFT JOIN loginSuccesses s ON s.user = u.id where s.user is NULL
idFirstNameLastName
3NeverAttemptedLogin
4WayneDawson