Test 2 Solution [Unitarius]

--Test 2 Solution

2.1

SELECT * FROM taba FULL JOIN tabb USING (author);

2.2

WITH cte AS (SELECT * FROM taba FULL JOIN tabb USING (author))

SELECT * FROM cte t1
WHERE EXISTS(SELECT 1 FROM cte t2
             WHERE t1.author = t2.author AND t1.book <> t2.book)