Using 2 aggregate functions

[harveenkaur]

Hi

I want to count cities having sum(Quantity)>1000 and sum(Sales)>1200 for the maximum month year in Date( In sample Data :- Sept. 2018)

Sample Data:

City	Quantity	Sales(Rs)	Date
C1	1000	2000	12-Sep-18
C2	12312	12310	13-Sep-18
C3	121	21223	12-May-18
C4	1212	1313	30-Aug-17
C1	1212	12123	20-Sep-18
C2	121	1313	08-Nov-18
C3	121	132	09-Nov-17