SELECT TOP 10 fld.run, fld.avg_sky_muJy, fld.runarea AS area, ISNULL(fp.nfirstmatch,0) FROM ( SELECT run, sum(primaryArea) AS runarea, 3631e6*avg(power(cast(10. as float),-0.4*sky_r)) as avg_sky_muJy FROM Field GROUP BY run ) AS fld LEFT OUTER JOIN ( SELECT p.run, count(*) AS nfirstmatch FROM FIRST AS fm INNER JOIN photoprimary as p ON p.objid=fm.objid GROUP BY p.run ) AS fp ON fld.run=fp.run ORDER BY fld.run
run | avg_sky_muJy | area | Column1 |
94 | 28904048.3342194 | 0.0449705088487448 | 298 |
109 | 138591386.007476 | 9.51161256860737 | 2127 |
125 | 44153130.356972 | 0.00150323268223015 | 0 |
211 | 21416142.4765477 | 5.92509366060802 | 129 |
240 | 17537965.4986299 | 0 | 0 |
241 | 11769171.1481953 | 0 | 0 |
250 | 10101392.3265459 | 0.881671633523299 | 839 |
251 | 13858667.309926 | 0.0583245114164519 | 0 |
256 | 21605847.6375708 | 0.000506867726435706 | 0 |
259 | 32534235.6832484 | 22.0192458866879 | 511 |