I have data in a jsonb column that looks like this...
{
"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": "Correct:Clear next steps were provided.",
"Comment": "Followup on fixing this issue."
}
}
What I want to do is get a count by question (1-4) of how many records have start with "Incorrect". I have the following query...
SELECT Count(reviews) FROM reviews WHERE review->'1'->>'Answer' LIKE 'Incorrect:%'
This will give me a count for that one question but I don't want to have 4 queries if I can help it. I've tried...
SELECT
Count(review->'1'->>'Answer' LIKE 'Incorrect:%') AS "Count1",
Count(review->'2'->>'Answer' LIKE 'Incorrect:%') AS "Count2"
FROM reviews;
But that counted all columns. Any ideas?
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…