1
@Entity
@NamedQueries({
@NamedQuery(name="Game.findPlayerPlayedOn",
query="select c.player from Game c where c.start > :starttime and c.end < :endtime")})

2
@Entity
@NamedQueries({
@NamedQuery(name="Game.findCertainPlayer",
query="select c.player, c.start, c.end from Game c where c.starttime > :starttime and c.endtime < :endtime")})

3
select player_playername, count(gameid) from game
group by player_playername
order by count(gameid) desc;

@Entity
@NamedQueries({
@NamedQuery(name="Game.findPlayerGame",
query="select c.player, count(c.gameid) from Game c group by c.player order by count(c.gameid) desc")})

4
select count(game_category.chosencategories_categoryid), category.category from game_category, category
where category.categoryid = game_category.chosencategories_categoryid

@Entity
@NamedQueries({
@NamedQuery(name="Game.findCategories",
query="select count(c.chosencategories_categoryid) from game_category c, category d where d.category = c.chosencategories_categoryid")})