Sample SQLs

Sample 1 Sample 2 Sample 3 Sample 4


SELECT top 100 sl.specObjId,

               sl.lineID,


               sMax.maxVel

-- get the spectroscopic object ID, the line ID, and the max width (in velocity)


FROM   SpecLine sl,

       (SELECT specObjID,

               lineID,

               Max(2.99e5 * 2.354 * sigma / wave) as maxVel


        FROM   SpecLine

        WHERE  (

               -- only include measured lines

               category = 2

               AND


               -- only include the most prominent lines

               lineID in ( 1215, 1400, 1549, 1909,


                           2799, 4863, 6565 )

               AND

               -- make sure that this is a reaonably well measured line


               -- (these are fairly weak constraints)

               nSigma > 3

               AND chisq / nu < 20

               AND ew > 0


               AND abs(ew - height * sigma * 1.065 * 2.354 / continuum) / ew < 0.25 )


        GROUP  BY specObjID,

                  lineID) as sMax

SQL before beautify

SELECT top 100  
sl.specObjId,  
sl.lineID,  
sMax.maxVel  
-- get the spectroscopic object ID, the line ID, and the max width (in velocity)  
FROM SpecLine sl,  
(SELECT  
specObjID,  
lineID,  
Max(2.99e5*2.354*sigma/wave) as maxVel  
FROM SpecLine  
WHERE (  
-- only include measured lines  
category = 2 AND  
-- only include the most prominent lines  
lineID in (1215,1400,1549,1909,2799,4863,6565) AND  
-- make sure that this is a reaonably well measured line  
-- (these are fairly weak constraints)  
nSigma > 3 AND  
chisq/nu < 20 AND  
ew > 0 AND  
abs(ew - height*sigma*1.065*2.354/continuum)/ew < 0.25  
)  
GROUP BY specObjID, lineID) as sMax