I have three tables books, author and publisher. I want a select query that lists all the book titles who publisher and author are from the same country. I try something like that but it didn’t work.
SELECT title
FROM books AS b, authors AS c, publishers AS p
WHERE c.country=p.publisher_country
GROUP BY title;