Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Valuation Measuring and managing the values of companies

Authors: Mckinsey, Tim Koller, Marc Goedhart, David Wessel

5th edition

978-0470424650, 9780470889930, 470424656, 470889934, 978-047042470

More Books

Students also viewed these Finance questions