Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started