> On 23/09/2007, Matt Magoffin <[EMAIL PROTECTED]> wrote:
>> Hello,
>>
>> My SQL skills are limited and I'm struggling with a query where I want
>> to
>> return a single item of an aggregate join. The query looks like this:
>>
>> select
>> (case
>> when agg.avg_rating is null then 0.0
>>
On 23/09/2007, Matt Magoffin <[EMAIL PROTECTED]> wrote:
> Hello,
>
> My SQL skills are limited and I'm struggling with a query where I want to
> return a single item of an aggregate join. The query looks like this:
>
> select
> (case
> when agg.avg_rating is null then 0.0
> when agg.avg_r
Hello,
My SQL skills are limited and I'm struggling with a query where I want to
return a single item of an aggregate join. The query looks like this:
select
(case
when agg.avg_rating is null then 0.0
when agg.avg_rating < 0.75 then 0.5
when agg.avg_rating < 1.25 then 1.0
when a
