You are given a log of status events for pages. Each row records a page turning on or off at a timestamp. A page is currently active if its most recent event has a status of 'on'. Return the total number of currently active pages.
Schema
page_status_log
log_idINTEGER
page_idINTEGER
statusVARCHAR
event_timestampTIMESTAMP
status values: 'on', 'off'
Target output