List the names and addresses of all guests in London, alphabetically ordered by name.
What will be an ideal response?
SELECT guestName, guestAddress FROM Guest WHERE address LIKE ‘%London%’
ORDER BY guestName;
Strictly speaking, this would also find rows with an address like: ‘10 London Avenue, New York’.
Computer Science & Information Technology
You might also like to view...
The Document Staging area is a centralized location for commands related to file management
Indicate whether the statement is true or false
Computer Science & Information Technology
What are two requirements needed to enable a 4 vCPU virtual machine with Fault Tolerance?
a. vSphere Enterprise Plus license b.1 GbE uplink for FT logging network c. vSphere Standard license d. 10GbE uplink for FT logging network
Computer Science & Information Technology