6039 collins ave apt 635

SQL/DATA MANIPULATION HOMEWORK

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 Mark NQTNB

6. If Phone number is in the Prior File Mark NQPRIOR

7. If Age is 1 or 2 Mark NQAGE

8. After steps 1 thru 7 if blank mark Qualified .

Date,Phone1 - Cell,Phone2 - Home,FirstName,LastName,FirstName2,LastName2,Address,City,State,Zip,Venue,Event,AgeRange,Income,Marital Status,Gender,Home/Rent,Market,Qualifications 7/12/2017,832-994-4768,,Natasha,,,,7575 Plum Creeck,Houston,TX,77084,SFFT,Six Flags Fiesta,4,4,1,,,San Antonio, 7/16/2017,956-739-7344,,Tanner,Perez,,,,Pharr,TX,78577,SFFT,Six Flags Fiesta,,,1,,,San Antonio, 7/16/2017,662-897-1021,,Juana,Cintora,Larry,S,319 Inspiration,North Carrollton,MS,38947,Six Flags,Six Flags,,,,,,Dallas, 7/15/2017,210-719-3751,,Antonio,Pratt,,,1207 Cullin Ave,San Antonio,TX,78228,SFFT,Crack Axle,3,,,,,San Antonio, 7/15/2017,254-466-6249,,D,Floyd,,,PO Box 48951,Killeen,TX,76549,SFFT,Crack Axle,3,3,1,,,San Antonio, 7/12/2017,214-288-9608,,Brixon,Layne,,,392 Hot Spring Valley,Dallas,TX,75204,Parks Mall,Parks Mall,3,2,2,,,Dallas, 7/10/2017,210-961-1032,,Brandon,O'Donnel,,,2830 Crest Point,San Antonio,TX,78230,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/14/2017,512-775-4866,,Jessica,P,,,2345 N Houston Apt # 315,Dripping Springs,TX,78620,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/11/2017,713-518-6099,,Kelly,Yslas,,,1600 N Ronney,Pasadena,TX,77503,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,000-413-9187,,Vianey,R,,,604 Campbell,Laredo,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/14/2017,915-541-5981,,Regina,Bise,,,,Denver,CO,80249,SFFT,Six Flags Fiesta,1,,1,,,San Antonio, 7/16/2017,786-461-0989,,Kyle,Reese,,,,Hialeah,FL,33012,SFFT,Crack Axle,1,4,1,,,San Antonio, 7/16/2017,818-310-2256,,Maria Rosario,L,,,,Tempe,AZ,85281,,LA Lobster Fest,2,2,1,,,LA, 7/10/2017,337-246-0938,,Edgar,Scott,,,,Jennings,LA,70546,SFFT,Six Flags Fiesta,2,3,1,,,San Antonio, 7/16/2017,465-518-5544,,Harry,Foster,,,,Baltimore,MD,21287,SFFT,Crack Axle,2,3,,,,San Antonio, 7/14/2017,602-668-5879,,Joseph,Zamora,,,,New River,AZ,85087,SFFT,Six Flags Fiesta,3,4,1,,,San Antonio, 7/12/2017,541-954-7726,,John,De Alba,Desiree,Neet,,Springfield,OR,97478,Six Flags,Six Flags,3,3,2,,,Dallas, 7/11/2017,913-240-0686,,Polette,Rodriguez,,,,Kansas City,MO,64130,SFFT,Six Flags Fiesta,4,,,,,San Antonio, 7/10/2017,736-345-6081,,Kimberlyn,Plumer,Lina,D Barrett,,Alamo,TN,38001,Six Flags,Six Flags,4,,,,,Dallas, 7/15/2017,337-570-9382,,Edwing,R,Jimmy,Jones,,Lake Charles,LA,70601,SFFT,Crack Axle,5,2,2,,,San Antonio, 7/14/2017,702-595-1848,,Kasey,,Brandy,N,17222 Tunin Rdg,Las Vegas,NV,89124,SFFT,Six Flags Fiesta,5,3,2,,,San Antonio, 7/16/2017,205-200-9257,,A,Gonzales,,,,Hayden,AL,35079,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/11/2017,318-762-2769,,Dianne,Patterson,Bruce,,,Shreveport,LA,71103,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/16/2017,318-789-3711,,Diego,,,,6219 Oxford Lake Dr,Monroe,LA,71211,Starplex,Third Eye Blind,,,,,,Dallas, 7/14/2017,318-612-6858,,Diana,Wilson,Bharti,Patel,,Minden,LA,71055,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/15/2017,915-227-3580,,Q,Gutierrez,Ofelia,Muniz,,Chaparral,NM,88081,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/14/2017,905-686-3620,,Pedro,Rangel,,,,Farmington,NM,87402,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,915-219-6026,,Priscilla,Quinones,,,,Chaparral,NM,88081,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,918-429-6788,,Riday,Duncan,,,,McAlester,OK,74501,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/16/2017,901-205-4440,,Nicole,Puente,,,,Memphis,TN,38128,Six Flags,Six Flags,,,,,,Dallas, 7/15/2017,512-308-2351,,Javier,Lacara,,,,Cedar Creek,TX,78612,SFFT,Six Flags Fiesta,3,4,3,,,San Antonio, 7/13/2017,210-627-5947,,Angeles,Santana,,,,Poteet,TX,78065,SFFT,Six Flags Fiesta,3,2,1,,,San Antonio, 7/13/2017,210-740-8705,,Arial,Galvan,,,,San Antonio,TX,78211,SFFT,Crack Axle,3,4,1,,,San Antonio, 7/14/2017,210-872-4606,,Beth,Wikenczy,Xavier,Arellano,1905 Nolas Ridge Dr,,,,SFFT,Six Flags Fiesta,3,3,2,,,San Antonio, 7/14/2017,210-501-6127,,Amy,Leedor,,,1207 South Mays,,,,SFFT,Crack Axle,1,3,1,,,San Antonio, 7/13/2017,210-584-0290,,Andrew,Galvan,,,1001 S 10th St 6-473rd,San Antonio,TX,,SFFT,Crack Axle,1,4,1,,,San Antonio, 7/11/2017,214-738-0879,,Chenee,Dunn,,,,Jarrell,TX,76537,SFFT,Six Flags Fiesta,1,4,1,,,San Antonio, 7/16/2017,210-524-3362,,Ana,Dunlap,,,562 Rattler Bluff,San Antonio,TX,,SFFT,Crack Axle,1,4,1,,,San Antonio, 7/16/2017,254-391-1823,,Cynthia,Worley,,,,Heighte,,76453,SFFT,SiX Flags Fiesta,1,,,,,San Antonio, 7/16/2017,619-721-0329,,Josue,Payton,,,,El Cajon,CA,92020,,LA Lobster Fest,2,4,1,,,LA, 7/13/2017,940-235-0395,,Romulo,Arellano,,,,Seymour,TX,76380,SFFT,Six Flags Fiesta,2,3,3,,,San Antonio, 3/13/2017,832-902-8301,,N,Ramirez,,,8901 Lonestar Rd,Austin,TX,,SFFT,Six Flags Fiesta,2,4,1,,,San Antonio, 7/16/2017,310-707-7237,,Deborah,Alvarado,,,3589 Hwy 51,,,,,LA Lobster Fest,2,4,1,,,LA, 7/15/2017,469-818-0227,,Jackie,Alondra,Denise,Najera,,Dallas,TX,75216,Grapevine Mills,Grapevine Mills,3,,1,,,Dallas, 7/15/2017,817-797-1982,,Mandell,Hudson,,,,Bedford,TX,76092,Starplex,Third Eye Blind,3,4,1,,,DFW, 7/16/2017,830-776-2661,,Matthew,Sellers,Ruth,Moreno,,Austin,TX,78701,SFFT,SiX Flags Fiesta,3,3,2,,,San Antonio, 7/14/2017,832-800-2686,,Monica,Apolinar,,,,San Antonio,TX,78245,SFFT,Crack Axle,3,1,1,,,San Antonio, 7/15/2017,956-205-3347,,Ryan,Peterson,Albert,Carrillo,,Mission,TX,78572,SFFT,Crack Axle,3,1,2,,,San Antonio, 7/10/2017,210-859-5590,,Ben,Estrada,,,,Austin,TX,78704,SFFT,Six Flags Fiesta,3,,1,,,San Antonio, 7/16/2017,001-608-5695,,A,Leal,,,,Dallas,TX,75116,Parks Mall,Parks Mall,3,4,2,,,Dallas, 7/15/2017,956-612-6102,,Summer,Martinez,Victor,Lopez,,Laredo,TX,78043,SFFT,Six Flags Fiesta,3,1,,,,San Antonio, 7/12/2017,214-206-6478,,Briana,Boffa,,,,Grand Prairie,TX,75052,Parks Mall,Parks Mall,3,4,1,,,Dallas, 7/15/2017,717-919-7799,,Kiley,Lujan,,,,Houston,TX,77048,Parks Mall,Parks Mall,3,,1,,,Dallas, 3/13/2017,210-787-9314,,Ashley,Cantu,Lenny,Miron,,San Antonio,TX,78201,SFFT,Six Flags Fiesta,3,,,,,San Antonio, 7/10/2017,713-677-9924,,Kendall,Cook,,,,San Antonio,TX,78238,SFFT,Six Flags Fiesta,3,4,1,,,San Antonio, 7/31/2017,210-391-9956,,Alisha,Sepulveda,,,,San Antonio,TX,78242,,Six Flags Fiesta,3,,1,,,San Antonio, 7/15/2017,323-363-1761,,Doltmer,Hipolito,,,1124 San Fernando,,,,Mesquite Rodeo,Mesquite Rodeo,3,1,1,,,Dallas, 7/16/2017,210-708-6220,,Anthony,Young,,,2332 San Paula Ave,,,,SFFT,Crack Axle,3,3,1,,,San Antonio, 7/10/2017,936-232-8173,,Roberto,Bailey,,,1008 W Felix St,,,,SFFT,Six Flags Fiesta,3,2,2,,,San Antonio, 7/13/2017,903-204-0118,,Noemi,Wiley,Thomas,Bean,,Mount Pleasant,TX,75455,Six Flags,Six Flags,4,4,2,,,Dallas, 7/19/2017,214-918-0793,,Christine,Herrera,,,,San Antonio,TX,78261,SFFT,Crack Axle,4,1,1,,,San Antonio, 7/16/2017,210-548-0850,,Andrea,Perez,Claudia,Estrada,2629 Pioneer St,San Antonio,TX,,SFFT,Crack Axle,4,4,,,,San Antonio, 7/11/2017,915-321-1636,,Raimah,T,,,,Fort Worth,TX,76119,Parks Mall,Parks Mall,4,4,,,,Arlington, 7/12/2017,903-497-2240,,Oscar,Jackson,,,,Mineola,TX,75773,Six Flags,Six Flags,4,4,1,,,Dallas, 7/14/2017,214-929-2461,,Christopher,Alvarado,,,1502 Belton Dr,Grand Saline,TX,,Six Flags,Six Flags,4,3,2,,,Dallas, 7/10/2017,210-365-2921,,Alexis,,,,1902 Winchester Dr,San Antonio,TX,78207,SFFT,Six Flags Fiesta,4,,,,,San Antonio, 7/15/2017,254-466-2933,,D,Hess,Amanda,Matthews,,Rosharon,TX,77583,SFFT,Crack Axle,4,1,2,,,San Antonio, 7/15/2017,903-742-3425,,Parks,Chavez,,,,Marshall,TX,75670,Six Flags,Six Flags,4,2,2,,,Dallas, 7/16/2017,832-602-5929,,Miguel,Gauna,,,,Houston,TX,77093,SFFT,Six Flags Fiesta,4,4,1,,,San Antonio, 7/15/2017,687-792-6457,,Karla,Vargas,,,,Cleburne,TX,76031,Starplex,Third Eye Blind,4,2,2,,,DFW, 7/10/2017,956-369-7281,,Sergio,A,Garza,,,Edcouch,TX,78538,SFFT,Six Flags Fiesta,4,,2,,,San Antonio, 7/14/2017,817-233-9707,,Lexi,Z,,,,Fort Worth,TX,76179,Grapevine Mills Mall,Grapevine Mills,4,3,1,,,Dallas, 7/11/2017,214-850-3112,,Christian,Franco,,,,Mesquite,TX,75149,American Airlines Center,Hall And Oates Concert,5,3,1,,,Dallas, 7/12/2017,409-939-4094,,Gary,F,,,,Arlington,TX,76002,Parks Mall,Parks Mall,5,,,,,Dallas, 7/14/2017,321-266-6962,,Dipen,F,Raymore,,,Georgetown,TX,78626,SFFT,Crack Axle,5,1,2,,,San Antonio, 7/15/2017,713-443-9331,,Keena,Vasquez,,,,Humble,TX,77396,SFFT,Six Flags Fiesta,5,,,,,San Antonio, 7/10/2017,817-923-0363,,Maria,Rodriguez,,,,Fort Worth,TX,76110,Parks Mall,Parks Mall,,,,,,Dallas, 7/16/2017,210-290-0665,,Akinwale,Barrett,,,,San Antonio,TX,78212,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/11/2017,214-980-0793,,Chuntalle,,,,8820 Westeimer Rd Apt #1403,Waxahachie,TX,75165,Six Flags,Six Flags,,,,,,Dallas, 7/16/2017,210-473-1348,,Ami,Garza,,,,San Antonio,TX,78209,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/10/2017,972-940-1381,,Ursula,Robles,,,107 Vivian Dr,Fort Worth,TX,,Parks Mall,Parks Mall,,,,,,Dallas, 7/15/2017,956-778-1484,,Taylor,Soto,,,,Santa Rosa,TX,78593,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,001-255-1800,,A,Cruz Soto,,,,Dallas,TX,75215,Parks Mall,Parks Mall,,,,,,Dallas, 7/12/2017,210-584-1805,,Andrew,Flores,,,,San Antonio,TX,78232,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,956-415-2141,,Sharon,Fuller,Priscilla,Fuentes,,McAllen,TX,78504,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/13/2017,214-913-2212,,Christine,Farias,,,,Dallas,TX,75231,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/13/2017,281-691-