-- returning the total number of devices and events seen by the system at a specific timestamp
SELECT
count(distinct device_id) as devices,
count(*) as events,
FROM table_a
  FOR SYSTEM_TIME AS OF “point_in_time_timestmap”;
)