The following query shows the username, email address, and bounce score for users with a bounce score greater than 1:
SELECT users.username, user_emails.email, user_stats.bounce_score
FROM users
INNER JOIN user_stats ON users.id = user_stats.user_id
INNER JOIN user_emails ON users.id = user_emails.user_id
WHERE user_stats.bounce_score > 1
ORDER BY user_stats.bounce_score DESC