WITH
cards AS (SELECT cardID, question, answer, essayOrder FROM `logs.latestEssaysCards` WHERE essayName="qcvc"),
samples AS (SELECT * FROM `logs.reviews` JOIN cards USING (cardID) WHERE reviewCount=1)
SELECT ANY_VALUE(a.cardID), ANY_VALUE(a.question), a.essayOrder, ANY_VALUE(b.cardID), ANY_VALUE(b.question), b.essayOrder , LOG((COUNTIF(a.reviewMarking=b.reviewMarking)/COUNTIF(a.reviewMarking!=b.reviewMarking))) AS logOddsRatio FROM samples AS a JOIN samples AS b USING (userID) WHERE a.essayOrder < b.essayOrder GROUP BY a.essayOrder, b.essayOrder ORDER BY logOddsRatio DESC