SELECT results.participants.auditor AS id, ROUND(unnest.accuracy, 3) AS accuracy, ROUND(unnest.bayesian.precision.posterior_mean, 3) AS precision_posterior_mean, ROUND(unnest.bayesian.recall.posterior_mean, 3) AS recall_posterior_mean, unnest.confusion_matrix.tp, unnest.confusion_matrix.tn, unnest.confusion_matrix.fp, unnest.confusion_matrix.fn FROM results CROSS JOIN UNNEST(results.results) AS unnest ORDER BY recall_posterior_mean DESC