Czy moze ktoś przerobić mi to zapytanie na hql? Siedze nad tym dość długo i cały czas mam błedy. Dopiero zaczynam przygodę z hql-em stąd moja prośba.
q2 (X,V FROM Regions):
SELECT reg.id, COUNT(acX.id) FROM Region AS reg
JOIN Location AS loc ON loc.regionId = reg.id
JOIN Building AS bld ON bld.locationId = loc.id
JOIN Zone AS zone ON zone.buildingId = bld.id
JOIN SubZone AS sz ON sz.zoneId = zone.id
JOIN Checklist AS cl ON cl.subZoneId = sz.id
JOIN ActivityCheck AS acX ON acX.checklistId = cl.id
WHERE acX.CHECK = "X" GROUP BY reg.id;