This question already has an answer here:
Is is possible in SEDE to write a query targeting many communities simultaneously?
I've seen this related question but it doesn't help me. e.g. I would like to see how many questions were asked in X, Y, and Z communities in the past 6 months.