Question

Write a query to display the customer's last name and city for all customers whose name ends with an "n" and the second letter of their city is an "a". Lastname city thompson santa monica nelson kalma

Answer 1

Answer:

select lastname,city from (tablename) where lastname like"n%" and where city="%a";

Explanation: