how else i can write this query

[sheida]

My query works. But is there other way to write it?

select Q1.paAmount, Q2.pAmount
From
(select sum(pa.amount) paAmount,pa.BookingID paBookingid from package_acct pa, Groups g , Person_Group pg where pa.PersonGroupId=pg.Id and pg.GroupId=g.Id group by pa.BookingID
)Q1
Inner Join
(SELECT sum(p.amount) pAmount, p.BookingID pbookingid FROM `payments` p where p.ispaid=1 group by p.BookingID
)Q2
on Q1.paBookingid=Q2.pBookingID