WHERE dep_time BETWEEN '10:00:00' AND '14:00:00' # WHERE HOUR(dep_time) BETWEEN '10' AND '14' ## 8. Calculate the average duration of flights between two cities. SELECt DISTINCT source,destination, ...
SUM(DECODE(DEPTNO, 10, SAL, 0)) AS "Dept 10 Sal", SUM(DECODE(DEPTNO, 20, SAL, 0)) AS "Dept 20 Sal", SUM(DECODE(DEPTNO, 30, SAL, 0)) AS "Dept 30 Sal", ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results