SQL challenge #2 – Language Chronicle

SQL challenge #2

Here is a solution to Iggy Fernandez The Second SQL challenge: WITH T(W2,OUT) AS ( SELECT WORD2, WORD1 || ‘ ‘ || WORD2 || ‘ ‘ || WORD3 FROM RIDDLE UNION ALL SELECT R.WORD2, T1.out || ‘ ‘ || R.WORD2 || ‘ ‘ || T2.out FROM T T1, RIDDLE R, T T2 WHERE T1.W2 = … Continue reading SQL challenge #2