Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Write a query to retrieve first name, last name, and zip of the customers where the first digit of zip code is 1 or 3
Write a query to retrieve first name, last name, and zip of the customers where the first digit of zip code is 1 or 3 and the last digit is any number between 3 and 7. Zip code is 5 digits code.
CustomerID | FirstName | LastName | Address | City | State | Zip | Country |
1 | John | Demarco | 11 Lark Street | New York | NY | 12189 | USA |
2 | Mary | Demania | 12 Madison Ave | New York | NY | 12189 | USA |
3 | George | Demers | 23 New Scotland Ave | New York | NY | 12189 | USA |
4 | Phillip | Demetriou | 22 Academy Road | New York | NY | 12189 | USA |
5 | Andrew | Demichele | 14 Glandel Ave | New York | NY | 12189 | USA |
6 | Michael | Demizio | 23 Grove Rd | New York | NY | 12189 | USA |
7 | Robert | Demaggio | 34 Princeton Dr | New York | NY | 12110 | USA |
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