Skip to Main Content
SQuizL

SQuizL - Guess the SQL statement

uiz
Guess #1 of 6
< Erase
Submit >
View results >
Complete this ↑ using these ↓ Press to guess ↑
() OVER (PARTITION
) VALUES (
,dir,lat,lon,
-DECODE (dir,'NS',
1,0) FROM highways
[cv()]
APPLY ( SELECT
BY dir ORDER BY
CASE WHEN
CAST (
DECODE (dir,'NS',
DEFAULT 'US',
DIMENSION BY
ELSE lat
GROUP
IF NOT EXISTS
IN ( 'NS', 'EW' )
INTO highways
IS NOT
lon,lat) DESC) * 2
MATCH_RECOGNIZE (
MODEL
WINDOW routes
WITH highways AS

Legend

= choice is in the correct position in the solution.
= choice is in the solution but was in the incorrect position.
= choice is not in the solution.