Write an SQL query that returns the street of all addresses in 'Stony Brook NY' that are destination of a trip on '5/14/02'.
Suppose a database has the following schema:
Trip(fromAddrId: INTEGER, toAddrId: INTEGER, date: DATE)
Address(id: INTEGER, street: STRING, townState: STRING)
SELECT A.street
FROM Address A, Trip T
WHERE A.id=T.toAddrId AND A.townState='Stony Brook NY'
AND T.date='05/14/02'
You might also like to view...
What will be output from the following code:
What will be an ideal response?
extract from input source the two components of a Vector object istream& operator>>( istream& is, Vect& avect )
What will be an ideal response?
Choose the sentence type of the following sentence.Lisa found five places that have wireless Internet.?
A. ?Simple B. ?Compound C. ?Complex D. ?Compound-complex
A server administrator is creating a design for a new datacenter. The servers should be configured for maximum availability and also provide caching for user information requests. Which of the following techniques should be used?
A. Active/Passive B. Round robin C. Heartbeat D. Active/Active E. Passive/Passive