SQL/DATA MANIPULATION
Qualifications
1. Make sure there are no dupes in file check by phone # if there are mark the one with the least amount of info Duplicate
2. Mark Incomplete if Record does not have one of the following Phone First Name Last Name Address City State Zip
3. If phone number is less than 10 digits Mark Bad Phone #
4. If record does not have the state as CA or TX mark Out of Area
5. If Phone number is in the TNB file IS ON TEST LEAD FILE Mark NQTNB
6. If Phone number is in the Prior File IS ON TEST LEAD FILE Mark NQPRIOR
7. If Age is 1 or 2 Mark NQAGE
8. After steps 1 thru 7 if blank mark Qualified
- Qualifications.csv
- TestLeads.csv
- Priors.csv
- TNB.csv
- Qualifications.csv
The post SQL/DATA MANIPULATION appeared first on Coursework Geeks.
“Is this question part of your assignment? We will write the assignment for you. click order now and get up to 40% Discount”

SQL/DATA MANIPULATION was first posted on August 5, 2019 at 11:44 am.
©2019 "Nursing Assignment". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at support@nursingassignment.org