1315 arrow bow san antonio tx

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-2229,,Danny,Vannoy,,,,Spring,TX,77386,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/13/2017,682-202-2298,,Judith,Lopez,,,,Fort Worth,TX,76133,Six Flags,Six Flags,,,,,,Dallas, 7/15/2017,409-363-2317,,Gabriel,McKinney,,,,Plano,TX,75024,Starplex,Third Eye Blind,,,,,,Dallas, 7/16/2017,225-772-2462,,Concepaon,Digoo,,,,Pflugerville,TX,78660,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,737-247-2559,,Kinsey,Solis,,,302 Benedict Rd,Austin,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/10/2017,361-759-2566,,Ever,,,,1905 W 19th St,Corpus Christi,TX,78411,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,956-472-2599,,Silvestre,Well,,,,Weslaco,TX,78599,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/10/2017,210-394-2644,,Allie,N,Marissa,Enriquez,,San Antonio,TX,78258,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/11/2017,956-309-2826,,Sarah,,,,234 W Montana Ave,Mission,TX,78572,SFFT,Six Flags Fiesta,,2,,,,San Antonio, 7/11/2017,325-206-2930,,Don Jamie,Horrice,,,12465 Crow Ranch Rd,San Angelo,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/12/2017,832-660-2949,,Mike,Hill,,,,Dickinson,TX,77539,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/12/2017,512-758-3052,,Jesol,V,,,,Pflugerville,TX,78660,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,972-965-3353,,V,Lujan,,,,Denton,TX,76208,Starplex,Third Eye Blind,,,,,,DFW, 7/16/2017,915-222-3356,,Prisila,Campos,,,,San Elizario,TX,79849,SFFT,Crack Axle,,,,,,San Antonio, 7/11/2017,682-204-3544,,Judy,Cotten,,,,Fort Worth,TX,76119,Six Flags,Six Flags,,,,,,Dallas, 7/13/2017,214-694-3554,,Charla,Kalk,,,PO Box 681,Dallas,TX,,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/16/2017,318-663-3965,,Diana,H,Ramon,Stetson,,San Antonio,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,361-208-4448,,Elizabeth,Rios,Travis,Randazzo,,Yoakum,TX,77995,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/13/2017,915-253-4598,,Rachael,Rodriguez,,,2108 Mayfield Ville Dr Apt #2106,El Paso,TX,,Six Flags,Six Flags,,,,,,Dallas, 7/16/2017,469-810-4754,,Jack,P,,,,Dallas,TX,75220,Grapevine Mills,Grapevine Mills,,,,,,Dallas, 7/16/2017,832-768-4846,,Mitchell,Hartfield,,,,Humble,TX,77346,Starplex,Third Eye Blind,,,,,,Dallas, 7/11/2017,210-904-5043,,Blanca,,,,1315 Loma Verde,San Antonio,TX,78202,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,956-436-5769,,Shawn,Smith,,,10714 Brahmer,Laredo,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,210-723-5801,,April,Jimenez,,,2613 Franklin Apt #914,Austin,TX,,Starplex,Third Eye Blind,,,,,,DFW, 7/11/2017,956-470-6148,,Silvester,L,Kassy,Garcia,4202 Emerson Dr,San Antonio,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,361-429-6332,,Eric,,,,1801 Lova Dr Apt # 127,Corpus Christi,TX,78411,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/11/2017,903-681-6355,,Pam,Meraviglia,,,,Grand Saline,TX,75140,Six Flags,Six Flags,,,,,,Dallas, 3/13/2017,915-676-6550,,Rene,Diaz,,,,El Paso,TX,79924,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,561-885-6551,,John,Collins,,,,San Antonio,TX,78252,SFFT,Six Flags Fiesta,,,,,,San Antonio, 6/12/2017,361-389-6756,,Enrique,Cobabe,,,,Inez,TX,77340,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/15/2017,214-687-6898,,Channing,M,,,,The Colony,TX,75056,Starplex,Third Eye Blind,,,,,,Dallas, 7/11/2017,210-454-6916,,Amber,Hernandez,,,,San Antonio,TX,78245,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/11/2017,682-307-7020,,Junio,C,,,950 E Bitters Rd Apt #411,Arlington,TX,,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/12/2017,214-642-7068,,Cecilia,Sanchez,,,,Desoto,TX,75115,Parks Mall,Parks Mall,,,,,,Dallas, 7/13/2017,832-706-7115,,Mina,Thomas,,,,La Porte,TX,77571,SFFT,Six Flags Fiesta,,,,,,San Antonio, 7/16/2017,210-859-7118,,Ben,Rogers,,,,San Antonio,TX,78280,SFFT,Six Flags Fiesta,,,,,,San Antonio,