Question: table [ [ CustomerID , CustomerFName,CustomerLName,City ] , [ 1 , Alice,Smith,New York ] , [ 2 , leb,Johnson,Los Angeles ] , [ 3

\table[[CustomerID,CustomerFName,CustomerLName,City],[1,Alice,Smith,New York],[2,leb,Johnson,Los Angeles],[3,Cheryl,Brown,Chicago],[4,Devin,Clark,Houston],[5,Eve,Davis,Phoenix]]
Consider the above CUSTOMERS table. Given the SQL query:
SELECT
C.CustomeriD
FROM Customers C
WHERE C.CustomerFName LIKE '%e';
Which of the following CustomerIDs will be returned by the query?
a.1 and 5
b.1 and 3
c.2 and 3
d.3 and 5
\ table [ [ CustomerID ,

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 Programming Questions!