select
        c.id,
        c.name,
        t.code,
        g.id,
        sum(e.balance)
    from Card e
    inner join e.generation g
    inner join g.type t
    inner join t.client c
    group by c.id, t.code, g.id
    order by c.name, t.code, g.id

    select
        t1_0.client_id,
        c2_0.name,
        g1_0.type_code,
        c1_0.generation_id,
        sum(c1_0.balance) 
    from
        Card c1_0 
    join
        Generation g1_0 
            on g1_0.id=c1_0.generation_id 
    join
        CardType t1_0 
            on t1_0.code=g1_0.type_code 
    join
        Client c2_0 
            on c2_0.id=t1_0.client_id 
    group by
        t1_0.client_id,
        g1_0.type_code,
        c1_0.generation_id 
    order by
        c2_0.name,
        g1_0.type_code,
        c1_0.generation_id

    select
        client3_.id as col_0_0_,
        client3_.name as col_1_0_,
        cardtype2_.code as col_2_0_,
        generation1_.id as col_3_0_,
        sum(card0_.balance) as col_4_0_ 
    from
        Card card0_ 
    inner join
        Generation generation1_ 
            on card0_.generation_id=generation1_.id 
    inner join
        CardType cardtype2_ 
            on generation1_.type_code=cardtype2_.code 
    inner join
        Client client3_ 
            on cardtype2_.client_id=client3_.id 
    group by
        client3_.id ,
        cardtype2_.code ,
        generation1_.id 
    order by
        client3_.name,
        cardtype2_.code,
        generation1_.id