Ok, let's all turn this into something a bit more "readable".

Duplicate of https://www.sqlservercentral.com/Forums/1907056/Union-ALl

Like I posted in your other topic today, please don't make a duplicate topic. If you post a question and you don't get the answer...

Without DDL, you're probably looking for using SUM with an OVER clause. Probably inside a CTE. This is all I can guess without DDL:

You already posted this question some 2 hours ago here: https://www.sqlservercentral.com/Forums/1907347/Query

Rather than posting a new topic, could you reply to Steve please? 🙂

Thanks.

No, the SQL Server Service account does not require Admin Privileges, and (in fact) should not.

The permissions a Service Account requires is going to vary from company to...

DDL would be really helpful here as looking at your data, you aren't storing your dates, as dates.

Firstly, have a look at having a Calendar table; they're a...

I have to agree with Steve, this is quite vague.

If, however, you need to treat the data from 2 separate tables separately, then don't UNION (ALL) them; then...

Couple of answers, might be a better way, but it's late in the day:

Your logic is a bit vague, you say between ages 13 and 21 in your subject, and 12-21 in your post. Also, when should they count? For example, if someone...