Find the time period when the most people were online. time online given in seconds. In either Python or SQL

person time_loggon_on time_online
A 2022-04-04 12:00:00 8000
B 2022-04-04 14:00:00 2000
C 2022-04-04 13:30:00 4000

Question

Find the time period when the most people were online.  time online given in seconds.  In either Python or SQL

person   time_loggon_on                   time_online
A                2022-04-04 12:00:00     8000
B                2022-04-04  14:00:00     2000
C                2022-04-04  13:30:00     4000

Amazon

Amazon Interview Question

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches