QUERY FOR VENTURA DEPLOY

SELECT AVG(firecmd_time) as firecmd_after_deploy, AVG(start_session_time) as start_session_time_after_deploy, count(*) as num FROM `browserstack-production.automate.automate_test_sessions_partitioned` 
WHERE DATE(_PARTITIONTIME) >= "2023-03-08" and DATE(_PARTITIONTIME) <= "2023-03-09"
and terminal in ("45.95.36.96",
"45.95.36.106",
"45.95.36.147",
"193.186.253.66",
"193.186.253.42",
"209.10.150.56",
"193.186.253.72",
"65.74.147.193",
"65.74.147.191",
"65.74.147.50",
"65.74.147.62",
"65.74.147.75",
"209.10.150.131",
"45.95.36.109",
"45.95.36.137",
"45.95.36.51",
"45.95.36.24",
"193.186.253.143",
"65.74.147.96",
"65.74.147.98",
"65.74.147.108",
"65.74.147.101",
"65.74.147.116",
"65.74.147.119",
"65.74.147.122",
"65.74.147.123",
"65.74.147.128",
"65.74.147.115",
"65.74.185.113",
"65.74.147.91",
"65.74.147.97",
"65.74.147.103",
"65.74.147.79",
"193.186.253.98",
"193.186.253.120",
"45.95.36.44",
"45.95.36.93",
"45.95.36.97",
"45.95.36.146",
"45.95.36.49",
"65.74.147.80",
"65.74.147.34",
"65.74.147.114",
"65.74.147.136",
"65.74.147.143",
"65.74.185.112",
"65.74.185.89",
"193.186.253.174")
and os = "OS X"
and os_version = "Ventura"