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'

Computer Science & Information Technology

You might also like to view...

What will be output from the following code:

What will be an ideal response?

Computer Science & Information Technology

extract from input source the two components of a Vector object istream& operator>>( istream& is, Vect& avect )

What will be an ideal response?

Computer Science & Information Technology

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

Computer Science & Information Technology

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

Computer Science & Information Technology