i have tried numerous attempts at rewriting this SQL in HQL. Im new enough so if someone coiuld rewrite query SQL to HQL Id be delighted.
reportID is primary key. userID is foreign key and repeated in report table.
MY HQL attempt
yet I get bad Invalid HQL query