[BP] % na poseteni gradovi od korisnik

SELECT
   round(
      (SELECT COUNT(DISTINCT g_id) FROM poseti, korisnici, lokacii WHERE poseti.k_id = korisnici.k_id AND poseti.l_id = lokacii.l_id AND poseti.k_id = 1)*100 /
      (SELECT COUNT(g_id) FROM gradovi)
   , 0)
FROM dual;