SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql query error

user10873676Aug 10 2020 — edited Aug 11 2020

select b.name, a.name, avg(c.humidity), case AVG(c.temperature) when <= 15 then 'COLD' WHEN >= 30 'HOT' ELSE 'WARM' end from country a, state b, state_weather_stats c where a.id = b.country_id and b.id = c.state_id and c.record_date between '2018-11-01' and '2018-11-30' group by a.name,b.name;

```
ERROR at line 1:
```
```
ORA-00936: missing expression
```

can someone help on this

Added on Aug 10 2020

6 comments

3,319 views