DECLARE
result JSON;
BEGIN
SELECT json_agg(json_build_object(
'id', qz.id,
'createdAt', qz.created_at,
'quizName', qz.quiz_name,
'quizDescription', qz.quiz_description,
'userId', qz.user_id,
'questions', (SELECT json_agg(json_build_object(
'id', qs.id,
'quizId', qs.quiz_id,
'question', qs.question,
'answer', qs.answer,
'createdAt', qs.created_at
)) FROM Questions qs WHERE qs.quiz_id = qz.id)
)) INTO result
FROM Quizzes qz;
RETURN result;
END;
DECLARE
result JSON;
BEGIN
SELECT json_agg(json_build_object(
'id', qz.id,
'createdAt', qz.created_at,
'quizName', qz.quiz_name,
'quizDescription', qz.quiz_description,
'userId', qz.user_id,
'questions', (SELECT json_agg(json_build_object(
'id', qs.id,
'quizId', qs.quiz_id,
'question', qs.question,
'answer', qs.answer,
'createdAt', qs.created_at
)) FROM Questions qs WHERE qs.quiz_id = qz.id)
)) INTO result
FROM Quizzes qz;
RETURN result;
END;