|
Last change
on this file since 19904 was 19893, checked in by tbretz, 5 years ago |
|
Updated queries, new query as resources
|
|
File size:
471 bytes
|
| Line | |
|---|
| 1 | SELECT
|
|---|
| 2 | INTERVAL(fZenithDistanceMean, %106:theta) AS `.theta`,
|
|---|
| 3 | INTERVAL(LogEnergyEst, %107:sparse) AS `.sparse_est`,
|
|---|
| 4 |
|
|---|
| 5 | -- Signal and Background counts
|
|---|
| 6 | COUNT(IF(Weight>0, 1, NULL)) AS `Signal`,
|
|---|
| 7 | COUNT(IF(Weight<0, 1, NULL)) AS `Background`,
|
|---|
| 8 |
|
|---|
| 9 | -- Average Energy
|
|---|
| 10 | SUM(Weight*POW(10, LogEnergyEst)) AS `SumEnergyEst`,
|
|---|
| 11 | SUM(Weight) AS `SumW`
|
|---|
| 12 | FROM
|
|---|
| 13 | Excess
|
|---|
| 14 | GROUP BY
|
|---|
| 15 | `.theta`, `.sparse_est`
|
|---|
| 16 | ORDER BY
|
|---|
| 17 | `.theta`, `.sparse_est`
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
