Question: Question 6 Show customers ( customer ID , postal code ) whose postal codes satisfy the following condition: Each code has nine characters. All characters
Question
Show customers customer ID postal code whose postal codes satisfy the following condition:
Each code has nine characters. All characters are digits except the sixth which is a dash On the other hand, the first character should always be An example of a valid postal code is
Please create a pattern match condition for postal code. Creating a condition for other columns eg country or using exact match will receive no credit.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
