Oracle SQL - Write SQL to list the cities in order by temperature

Requirements

Here is the table

Demo

SQL>
SQL> drop table Report;

Table dropped.-- from ww  w. ja v a 2 s.com

SQL> create table Report (
  2  City         VARCHAR2(11),
  3  Temperature  NUMBER,
  4  Humidity     NUMBER,
  5  Condition    VARCHAR2(9)
  6  );
SQL>
SQL> insert into Report values ('BOOK2S.COM',89,98,'CLEAR');
SQL> insert into Report values ('ROME',45,79,'RAIN');
SQL> insert into Report values ('PARIS',81,62,'CLOUDY');
SQL> insert into Report values ('MANCHESTER',66,98,'FOG');
SQL> insert into Report values ('ATHENS',97,89,'SUNNY');
SQL> insert into Report values ('CHICAGO',66,88,'RAIN');
SQL> insert into Report values ('SYDNEY',69,99,'SUNNY');
SQL> insert into Report values ('SPARTA',74,63,'CLOUDY');
SQL> insert into Report values ('BEIJING',104,83,'SMOG');
SQL> insert into Report values ('NEW YORK',100,93,'SUNNY');
SQL>

Write SQL to list the cities in order by temperature

Demo

SQL>
SQL>-- from  www . j  a v a 2  s  .c  o  m
SQL> select City, Temperature from Report
  2  order by Temperature ;

CITY        TEMPERATURE
----------- -----------
ROME                 45
MANCHESTER           66
CHICAGO              66
SYDNEY               69
SPARTA               74
PARIS                81
BOOK2S.COM           89
ATHENS               97
NEW YORK            100
BEIJING             104

10 rows selected.

SQL>