MySQL query to get all fields of customer having Y in their firstname or lastname in ascending order of their city names
MySQL select query, we will perform below actions. List all customers who is activeList all customers who is active and ‘Y’ in their firstnameList all customers who is active and…