Question
penPount - ILA3 reviX+
K3A%2F9%2F5f10ccf-42fe-41ae-a18f-a4e0177dec3 3.sequences.apibrightspace.com%2F167558%2Factivity%255622176%3FfiterOnt
Google Docs how many days sin. Email-LIM VAU BL.. Home-Netflix WhatsApp 9anime -Watch Ani.
202252 ICA3
Time Left:0:29:34
LIM YAU BIN STU-SBM: Attempt 1
Question 1 (1 point)
Below is a partial screenshot of 1 table in a business database that assigns riders to
dispatches to make customer deliveries. Which SQL statement will properly retrieves
data from the fields "VEHICLETYPE" and "ORDER cODE" where the "ZONE" is
equal to T1?
TABLE: Riders Table
RIDER 1DRIDER NAME ZONEVEHICLE TYPE
RO001JR Joanhe Robinson11 PMD
Motorcycle
Jax Campbel BM3 Motorcycle
ORDER CODE DISPATCH TIME
P100023
P100370
P100592
11:23
RO002AB
Amal Bloges
12:15
RO003JC
12:45
Select ORDER_CODE, VEHICLE TYPE from Riders_ Table WHERE ZONE
EQUALS TO T1
Select VEHICLE TYPE. RIDER NAME from Riders Table WHERE ZONE
EQUALS TO T1
Select RIDER_ID, ORDER_CODE from Riders_Table WHERE ZONE=T1
Select VEHICLE TYPE, ORDER_CODE from Riders Table WHERE ZONE='T1'
Answer
SELECT VEHICLE TYPE, ORDER_CODE FROM Riders Table WHERE ZONE='T1'