Subversion Repositories SmartDukaan

Rev

Rev 11336 | Rev 11583 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 11336 Rev 11512
Line 116... Line 116...
116 
        SUM((age >= 3 and age < 4) * currentQuantity) AS threeToFourCount,
116 
        SUM((age >= 3 and age < 4) * currentQuantity) AS threeToFourCount,
117 
        SUM((age >= 4) * currentQuantity) as fourPlusCount,
 117 
        SUM((age >= 4) * currentQuantity) as fourPlusCount,
118 
        SUM((age >= 1) * currentQuantity) as onePlusCount,
 118 
        SUM((age >= 1) * currentQuantity) as onePlusCount,
119 
        SUM((age >= 13) * currentQuantity) as threeMonthPlusCount,
 119 
        SUM((age >= 13) * currentQuantity) as threeMonthPlusCount,
120 
        SUM((age >= 26) * currentQuantity) as sixMonthPlusCount,
 120 
        SUM((age >= 26) * currentQuantity) as sixMonthPlusCount,
121 
        SUM((age > 0) and (age <= 13) * currentQuantity) AS zeroToThreeMonthCount,
 121 
        SUM((age > 0 and age <= 13) * currentQuantity) AS zeroToThreeMonthCount,
122 
        SUM((age > 13) and (age <= 26) * currentQuantity) AS threeToSixMonthCount,
 122 
        SUM((age > 13 and age <= 26) * currentQuantity) AS threeToSixMonthCount,
123 
        SUM((age > 26) and (age <= 52) * currentQuantity) AS sixToTwelveMonthCount,
 123 
        SUM((age > 26 and age <= 52) * currentQuantity) AS sixToTwelveMonthCount,
124 
        SUM((age > 52) * currentQuantity) AS twelveMonthsPlusCount,
 124 
        SUM((age > 52) * currentQuantity) AS twelveMonthsPlusCount,
125 
        SUM((age >= 1) * unitPrice*currentQuantity) as onePlusCost,
 125 
        SUM((age >= 1) * unitPrice*currentQuantity) as onePlusCost,
126 
        SUM(currentQuantity) as zeroPlusCount,
 126 
        SUM(currentQuantity) as zeroPlusCount,
127 
        SUM(l.unitPrice*currentQuantity) as zeroPlusCost,
 127 
        SUM(l.unitPrice*currentQuantity) as zeroPlusCost,
128 
        l.productGroup as category
 128 
        l.productGroup as category