SQL Murder Mystery Solution

WITH cte AS
(SELECT SQL AS name FROM sqlite_master WHERE SQL LIKE 'CREATE TRIGGER%'
),
pos AS
(SELECT charindex('hex(new.value)',name) pos, name FROM cte
UNION ALL
SELECT pos+charindex('hex(new.value)',substr(name, pos+1, LENGTH(name))) pos, name FROM pos
WHERE charindex('hex(new.value)',substr(name, pos+1, LENGTH(name)))>0
)

SELECT
p.name AS [Solutions]
FROM pos
INNER JOIN person p ON hex(p.name) =  substr(pos.name, pos + 17, charindex('''', pos.name, pos + 17) - (pos + 17))