[SQL]lentezza query

[skidx]

Prova così:

select X, Y, Z 
from tabella 
INNER JOIN 
(select X from tabella 
      group by X 
      having count(*) > 20) as tabella2
ON tabella.X = tabella2.X