Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

WITH mytable AS (
    SELECT
        '{ "1": { "Answer": "Incorrect:No" }, "2": { "Answer": "Correct:The troubleshooting steps are correct", "Comment": "Computer was not restarted." }, "3": { "Answer": "Correct:The actions taken were correct" }, "4": { "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." } }'::json as mydata
)
SELECT 
    * 
FROM mytable,
    json_each(mydata) as data


mydata
key
value


{ "1": { "Answer": "Incorrect:No" }, "2": { "Answer": "Correct:The troubleshooting steps are correct", "Comment": "Computer was not restarted." }, "3": { "Answer": "Correct:The actions taken were correct" }, "4": { "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." } }
1
{ "Answer": "Incorrect:No" }

{ "1": { "Answer": "Incorrect:No" }, "2": { "Answer": "Correct:The troubleshooting steps are correct", "Comment": "Computer was not restarted." }, "3": { "Answer": "Correct:The actions taken were correct" }, "4": { "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." } }
2
{ "Answer": "Correct:The troubleshooting steps are correct", "Comment": "Computer was not restarted." }

{ "1": { "Answer": "Incorrect:No" }, "2": { "Answer": "Correct:The troubleshooting steps are correct", "Comment": "Computer was not restarted." }, "3": { "Answer": "Correct:The actions taken were correct" }, "4": { "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." } }
3
{ "Answer": "Correct:The actions taken were correct" }

{ "1": { "Answer": "Incorrect:No" }, "2": { "Answer": "Correct:The troubleshooting steps are correct", "Comment": "Computer was not restarted." }, "3": { "Answer": "Correct:The actions taken were correct" }, "4": { "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." } }
4
{ "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." }


WITH mytable AS (
    SELECT
        '{ "1": { "Answer": "Incorrect:No" }, "2": { "Answer": "Correct:The troubleshooting steps are correct", "Comment": "Computer was not restarted." }, "3": { "Answer": "Correct:The actions taken were correct" }, "4": { "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." } }'::json as mydata
)
SELECT 
    * 
FROM mytable,
    json_each(mydata) as data
WHERE data.value ->> 'Answer' LIKE 'Incorrect%'


mydata
key
value


{ "1": { "Answer": "Incorrect:No" }, "2": { "Answer": "Correct:The troubleshooting steps are correct", "Comment": "Computer was not restarted." }, "3": { "Answer": "Correct:The actions taken were correct" }, "4": { "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." } }
1
{ "Answer": "Incorrect:No" }

{ "1": { "Answer": "Incorrect:No" }, "2": { "Answer": "Correct:The troubleshooting steps are correct", "Comment": "Computer was not restarted." }, "3": { "Answer": "Correct:The actions taken were correct" }, "4": { "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." } }
4
{ "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." }


WITH mytable AS (
    SELECT
        '{ "1": { "Answer": "Incorrect:No" }, "2": { "Answer": "Correct:The troubleshooting steps are correct", "Comment": "Computer was not restarted." }, "3": { "Answer": "Correct:The actions taken were correct" }, "4": { "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." } }'::json as mydata
)
SELECT 
    COUNT(*) 
FROM mytable,
    json_each(mydata) as data
WHERE data.value ->> 'Answer' LIKE 'Incorrect%'


count


2

mydata	key	value
{ "1": { "Answer": "Incorrect:No" }, "2": { "Answer": "Correct:The troubleshooting steps are correct", "Comment": "Computer was not restarted." }, "3": { "Answer": "Correct:The actions taken were correct" }, "4": { "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." } }	1	{ "Answer": "Incorrect:No" }
{ "1": { "Answer": "Incorrect:No" }, "2": { "Answer": "Correct:The troubleshooting steps are correct", "Comment": "Computer was not restarted." }, "3": { "Answer": "Correct:The actions taken were correct" }, "4": { "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." } }	2	{ "Answer": "Correct:The troubleshooting steps are correct", "Comment": "Computer was not restarted." }
{ "1": { "Answer": "Incorrect:No" }, "2": { "Answer": "Correct:The troubleshooting steps are correct", "Comment": "Computer was not restarted." }, "3": { "Answer": "Correct:The actions taken were correct" }, "4": { "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." } }	3	{ "Answer": "Correct:The actions taken were correct" }
{ "1": { "Answer": "Incorrect:No" }, "2": { "Answer": "Correct:The troubleshooting steps are correct", "Comment": "Computer was not restarted." }, "3": { "Answer": "Correct:The actions taken were correct" }, "4": { "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." } }	4	{ "Answer": "Incorrect:Clear next steps were provided.", "Comment": "Followup on fixing this issue." }