SELECT count(facultate.id) as vizualizari, facultate.nume
from preferinte_faculati
left join user on user.id = preferinte_faculati.id_user
left join facultate on facultate.id = preferinte_faculati.id_facultate
WHERE user.hobby = 'Calculatoare'
GROUP BY facultate.id