-
Notifications
You must be signed in to change notification settings - Fork 0
/
simple-early-late.sql
67 lines (55 loc) · 1.91 KB
/
simple-early-late.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
-- Lung, BY AJCC, EXCLUDE SMALL CELL
SELECT count(*) as n, Stagegroupingajcc
FROM [ORD_Singh_202001030D].[Src].[Oncology_Oncology_Primary_165_5]
where (SitegpX like 'lung%' or ICDOSite like 'lung%' or PrimarysiteX like 'lung%')
and not HistologyIcdo3X like 'small%' and not HistologyIcdo3X like 'carcinoid%' and not HistologyIcdo3X like 'neuro%'
group by Stagegroupingajcc
order by n desc
/*
n Stagegroupingajcc
21749 I
12729 IV
10144 III
8877 NULL
5852 II
2645 Unk/Uns
258 NA
212 0
*/
-- EARLY
SELECT count(*)
FROM [ORD_Singh_202001030D].[Src].[Oncology_Oncology_Primary_165_5]
where (SitegpX like 'lung%' or ICDOSite like 'lung%' or PrimarysiteX like 'lung%')
and not HistologyIcdo3X like 'small%' and not HistologyIcdo3X like 'carcinoid%' and not HistologyIcdo3X like 'neuro%'
and (Stagegroupingajcc = 'I' or Stagegroupingajcc = 'II' or Stagegroupingajcc = '0')
--27813
--LATE
SELECT count(*)
FROM [ORD_Singh_202001030D].[Src].[Oncology_Oncology_Primary_165_5]
where (SitegpX like 'lung%' or ICDOSite like 'lung%' or PrimarysiteX like 'lung%')
and not HistologyIcdo3X like 'small%' and not HistologyIcdo3X like 'carcinoid%' and not HistologyIcdo3X like 'neuro%'
and (Stagegroupingajcc = 'III' or Stagegroupingajcc = 'IV')
--22873
-------- COLON --------
select count(*) as n, [StageGroupingajcc]
FROM [ORD_Singh_202001030D].[Src].[Oncology_Oncology_Primary_165_5]
where (SitegpX like 'colo%' or ICDOSite like 'colo%' or PrimarysiteX like 'colo%')
and not (Histologyicdo3X like '%carcinoid%' or
Histologyicdo3X like '%neuro%' or
Histologyicdo3X like '%adenoma%' or
Histologyicdo3X like '%lymph%' or
Histologyicdo3X like 'gastrointestinal strom%' or
Histologyicdo3X like '%sarcoma%')
group by StageGroupingajcc
order by n desc
/*
n StageGroupingajcc
6781 II
6699 I
5897 III
2790 IV
2469 NULL
1999 Unk/Uns
1738 0
28 NA
*/