| SELECT ceiling(zoneId/10) AS zoneGroup, count(*) AS
detectionCount |
|
|
|
|
SELECT ceiling(zoneId/10)
AS zoneGroup, count(*) AS detectionCount |
| FROM P2Detection |
|
FROM
P2Detection |
| GROUP
BY ceiling(zoneId/10) |
|
WHERE
raErr < 0.1 AND
decErr < 0.05 |
| ORDER
BY ceiling(zoneId/10) |
|
GROUP BY ceiling(zoneId/10) |
|
|
|
ORDER BY ceiling(zoneId/10) |
| zoneGroup |
detectionCount |
|
|
|
zoneGroup |
hqDetectionCount |
|
| 1126 |
5 |
|
|
1127 |
2 |
|
| 1127 |
60 |
|
|
1128 |
3 |
|
| 1128 |
109 |
|
|
1129 |
2 |
|
| 1129 |
106 |
|
|
1130 |
6 |
|
| 1130 |
132 |
|
|
1131 |
3 |
|
| 1131 |
144 |
|
|
1132 |
4 |
|
| 1132 |
145 |
|
|
1134 |
2 |
|
| 1133 |
161 |
|
|
1136 |
6 |
|
| 1134 |
161 |
|
|
1137 |
1 |
|
| 1135 |
168 |
|
|
1138 |
4 |
|
| 1136 |
187 |
|
|
1139 |
8 |
|
| 1137 |
180 |
|
|
1140 |
3 |
|
| 1138 |
206 |
|
|
1142 |
3 |
|
| 1139 |
186 |
|
|
1143 |
5 |
|
| 1140 |
223 |
|
|
1144 |
4 |
|
| 1141 |
239 |
|
|
1145 |
5 |
|
| 1142 |
214 |
|
|
1146 |
6 |
|
| 1143 |
214 |
|
1147 |
2 |
|
| 1144 |
208 |
|
1148 |
4 |
|
| 1145 |
234 |
|
1149 |
2 |
|
| 1146 |
216 |
|
1151 |
3 |
|
| 1147 |
196 |
|
1152 |
4 |
|
| 1148 |
202 |
|
1154 |
4 |
|
| 1149 |
215 |
|
1155 |
1 |
|
| 1150 |
203 |
|
1156 |
3 |
|
| 1151 |
225 |
|
1157 |
4 |
|
| 1152 |
184 |
|
1158 |
1 |
|
| 1153 |
181 |
|
1159 |
2 |
|
| 1154 |
156 |
|
1160 |
3 |
|
| 1155 |
145 |
|
| 1156 |
163 |
|
| 1157 |
171 |
|
| 1158 |
134 |
|
| 1159 |
100 |
|
| 1160 |
110 |
|
| 1161 |
88 |
|
| 1162 |
29 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
