Question: I need solution to this SQL question: Write the SQL code for the following: Display the last name and street address of the customers who

I need solution to this SQL question: Write the SQL code for the following: Display the last name and street address of the customers who live in Negley.
a. SELECT LastName, StreetAddress
FROM Addresses
WHERE StreetAddress LIKE "*Negley*";
b. SELECT LastName, StreetAddress
FROM Customers
WHERE StreetAddress='Negley';
c. SELECT LastName, StreetAddress
WHERE StreetAddress
LIKE "*Negley*";
d. SELECT LastName, StreetAddress
FROM Customers
WHERE StreetAddress
LIKE "*Negley*";

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!