0
I need to answer this question: 4) Find the name and address of the customers who rented all the films from the video store.
I don’t have a way to test the query, but I will do something like this?
SELECT C.nome, C.endereço from CLIENTES C
WHERE EXISTS (
SELECT * FROM filmes F
WHERE EXISTS (
SELECT * from locaçoes L
where F.id = L.filme and C.id = L.cliente
)
)
The question is not very clear: do you want to list the data of customers who have already rented absolutely ALL the films from the video store, that is, that there is no lack of film to be rented? If so, the query would have to be quite different from this.
– Loudenvier