[BP] najposetuvani gradovi

SELECT vk.g_id, vk_poseti, gradovi.g_ime FROM
    (SELECT lokacii.g_id, COUNT(poseti.l_id) AS vk_poseti
     FROM lokacii, poseti
     WHERE lokacii.l_id = poseti.l_id
     GROUP BY lokacii.g_id) vk, gradovi
WHERE
    vk.g_id = gradovi.g_id
ORDER BY vk_poseti DESC