I have a situation more or less like this:
A table with the records, I need to do a search with two references, example select * from CARS where dealership = 'VW' or vehicle = 'VW' AND location = 'Sao Paulo'
This search returns me all VW cars and regardless of location, it ignores the second condition.
I would need it to filter inside the location "São Paulo" would make a second filter bringing the data of cars or dealerships that I ordered.
My result is type:
VW GOL SP
VW JETTA MG
It should prevent this second - because it is out of SP.