select * from Pis p, Vivenda v
WHERE p.escala = 'B' AND p.planta = 2 AND p.porta = 3
GROUP BY (v.nom_zona like %A) ;