Hello, I do not know the structure of your tables, so I'll try to help you ...
select livros.titulo,
autor.pais
From livros inner join livro_autor
On livros.objectid = livro_autor.objectidlivro
Inner join autor
On autor.objectid = livro_autor.objectidautor
where autor.pais = 'Brasil'
livros.titulo
should be replaced with the name of the column in which the title information in your books table is. (% with%)
Livros.nome_da_coluna
should be replaced with the name of the column where the country information is in the author table. (% with%)
In the inner join, where autor.pais
is to be replaced by the name of the column where the information that is related in your tables is located, initially in the books table, then in the Autor.nome_da_coluna
that relates to books. Then the author table column that relates to the objectid
table.
I hope I have helped you, if you have been a bit confused, please inform the names of these columns that I re-assemble the correct script.
Please let me know if it works.