Combine query to get data month wise, between two dates and on current date

Hii Experts

My Client has different departments

Now i have to create a department wise report which has some columns i.e.
Department Name , Booking on current Month(quantity), Total order pending till Date(Quantity) , Current date Booking(Card Name, quantity)

Please help in that

Regards

Ambesh