prova questa
codice:
SELECT * FROM registrazione where `data` ='2018-10-22' and idautista IN 
(
SELECT idautista FROM registrazione where `data` ='2018-10-22' GROUP BY `idautista` HAVING count(*)>1
)