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!