2个计数并将结果组合为一列| SQL Server Management Studio

发布于 2025-02-10 03:16:15 字数 715 浏览 0 评论 0原文

我试图根据某些登记日期和创建日期在数据库中对数据库中的不同ID进行计数。

tables:
 - people p
 - number n
 - message m
 - volume v

要求

在链接到ID的数字的情况下；最古老的数字之间的时间registrationDateTime和Message.CreationDateTime＆lt; = 10 wd
，如果链接到ID的音量（和没有数字）；最古老的数字之间的时间registrationDateTime和Message.CreationDateTime＆lt; = 10 wd

均应总计计数为

查询的我计数：

count（case cast deDiff（dw，dw，n.RegistrationDateTime，m.creationdateTime，m.creationdateTime）＆lt; lt; = 10然后p.id end作为a
，count（dw，dw，v.registrationDateTime，m.creationdatetime）＆lt; = 10 then p.id end as a

我的问题;

Im trying to do a count of distinct Id's of people in a database based on some registrationdate and creationdate.

tables:
 - people p
 - number n
 - message m
 - volume v

Requirements

In case of a number linked to the Id;
the time between the oldest number.registrationdatetime and message.creationdatetime <= 10 wd
In case of a volume (and no number) linked to the Id;
the time between the oldest number.registrationdatetime and message.creationdatetime <= 10 wd

Both should be counted in total as A

my count part of the query:

count (case when datediff(dw, n.registrationdatetime , m.creationdatetime) <=10 then p.id end as A
,count (case when datediff(dw, v.registrationdatetime , m.creationdatetime) <=10 then p.id end as A

my question;