create multiple counts in one SQL query

Question

I would like to get the number of users per airline per end of each month of one year. Sadly I am only able to get the result per one month. Is it somehow possible to get a table with multiple counts per month in such a way that I don't have to do it all one by one?

That's the query I have for one month:

SELECT  
    COUNT (ID) as Counts, 
    AirlineCode   
FROM [liveDB].[dbo].[AppUser]   
WHERE CreateDate<'2016-10-30'
GROUP BY AirlineCode

Thanks a lot Andreas

Your current query is grouping by the airlinecode - not by passenger. Add some sample data, and your table structure. Use the following as a guide: spaghettidba.com/2015/04/24/… — Eli
– Eli, Commented Sep 1, 2017 at 17:44
@scaisEdge I think Stack Overflow's auto-tagger is really bad at these things. — tadman
– tadman, Commented Sep 1, 2017 at 17:56
@tadman I agree with you .. tags are always added unnecessarily — ScaisEdge
– ScaisEdge, Commented Sep 1, 2017 at 17:57
@scaisEdge Other hypothesis is people think it's the "Mycrosoft SQL Server". — tadman
– tadman, Commented Sep 1, 2017 at 17:59

S3S · Accepted Answer · 2017-09-01 17:58:21Z

1

Just add the month to the select and group by.

SELECT  
    COUNT (ID) as Counts, 
    ,TheMonth = datepart(month,CreateDate)
   , AirlineCode   
FROM [liveDB].[dbo].[AppUser]   
WHERE CreateDate<'2016-10-30'
GROUP BY AirlineCode, datepart(month,CreateDate)

answered Sep 1, 2017 at 17:58

S3S

25.2k5 gold badges29 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

create multiple counts in one SQL query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related