MySQL计算时间段内的多个条目，共享至少3列中的1列

I have a table that logs invalid user login attempts. Every time an invalid attempt is made, the username, user IP, user email and time/date is stored in the database.I have a table that logs invalid user login att