I want to find out average time on SQL Big Query. I tried using the CAST function but it's not working. For example-
Ride_length
01:01:00
00:58:00
01:14:00
00:34:00
01:03:00
00:34:00
00:40:00
01:00:00
there are 5451210 rows in ride_length column. Date type = TIME
Please help!