-- number of test-edit attempts started
SELECT
name,
COUNT(1) AS n_events
FROM event.wikifunctions_ui
WHERE
name = 'wf.ui.defaultView.load' 
AND element_at(custom_data, 'edit').value = 'true'  
AND element_at(custom_data, 'zobjecttype').value = 'Z20' 
AND  element_at(custom_data, 'isnewzobject').value = 'false'
AND Year >= 2023
GROUP BY 
name

-- number of test-edit attempts published
SELECT
name,
COUNT(1) AS n_events
FROM event.wikifunctions_ui
WHERE
name = 'wf.ui.editTester.publish' 
AND  element_at(custom_data, 'isnewzobject').value = 'false'
AND Year >= 2023
GROUP BY 
name

-- number of implementation edit attempts started
SELECT
name,
COUNT(1) AS n_events
FROM event.wikifunctions_ui
WHERE
name = 'wf.ui.defaultView.load' 
AND element_at(custom_data, 'edit').value = 'true'  
AND element_at(custom_data, 'zobjecttype').value = 'Z14' 
AND  element_at(custom_data, 'isnewzobject').value = 'false'
AND Year >= 2023
GROUP BY 
name

-- number of implementation edit attempts published
SELECT
name,
COUNT(1) AS n_events
FROM event.wikifunctions_ui
WHERE
name = 'wf.ui.editImplementation.publish' 
AND  element_at(custom_data, 'isnewzobject').value = 'false'
AND Year >= 2023
GROUP BY 
name