I am running a query to extract some data from a table, it is working fine in the table plus / Metabase but it is throwing error in google bigquery.

**Query: **
SELECT
feedbacks. “postedById” AS “userid”,
TRIGGER,
status,
payload -> ‘scale’ AS scale,
payload -> ‘value’ AS “feedbackvalue”,
(
SELECT
string_agg(DISTINCT jsonb_extract_path_text(answers, ‘answers’), ‘”, “‘) AS answers
FROM
jsonb_array_elements(feedbacks.payload -> ‘survey’) AS answers),
users.type AS “user_type”
FROM
feedbacks
LEFT JOIN users ON feedbacks. “postedById” = users.id

The below query is working in google bigquery:
SELECT
feedbacks. “postedById” AS “userid”,
TRIGGER,
status,
(
SELECT
string_agg(DISTINCT jsonb_extract_path_text(answers, ‘answers’), ‘”, “‘) AS answers
FROM
jsonb_array_elements(feedbacks.payload -> ‘survey’) AS answers),
users.type AS “user_type”
FROM
feedbacks
LEFT JOIN users ON feedbacks. “postedById” = users.id

what I am doing wrong?

I have tried googling but the solutions don’t work. Actually i am not able to find relevant answers only.