Question

ii) Write an SQL query that returns the titles of articles authored by 'Robert Tarjan'.

Answer 1

SELECT title
FROM Authoring
         JOIN Articles A on A.id = Authoring.articleId
         JOIN Authors A2 on A2.id = Authoring.authorId
WHERE A2.name = 'Robert Tarjan';