| ==== |
| ---- QUERY: TPCDS-Q34 |
| select |
| c_last_name, |
| c_first_name, |
| c_salutation, |
| c_preferred_cust_flag, |
| ss_ticket_number, |
| cnt |
| from |
| (select |
| ss_ticket_number, |
| ss_customer_sk, |
| count(*) cnt |
| from |
| store_sales, |
| date_dim, |
| store, |
| household_demographics |
| where |
| store_sales.ss_sold_date_sk = date_dim.d_date_sk |
| and store_sales.ss_store_sk = store.s_store_sk |
| and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk |
| and (date_dim.d_dom between 1 and 3 |
| or date_dim.d_dom between 25 and 28) |
| and (household_demographics.hd_buy_potential = '>10000' |
| or household_demographics.hd_buy_potential = 'Unknown') |
| and household_demographics.hd_vehicle_count > 0 |
| and (case when household_demographics.hd_vehicle_count > 0 |
| then (1.0 * household_demographics.hd_dep_count) / (1.0 * household_demographics.hd_vehicle_count) |
| else null end) > 1.2 |
| and date_dim.d_year in (1999, 1999 + 1, 1999 + 2) |
| and store.s_county in ('Williamson County','Williamson County','Williamson County','Williamson County', |
| 'Williamson County','Williamson County','Williamson County','Williamson County') |
| group by |
| ss_ticket_number, |
| ss_customer_sk |
| ) dn, |
| customer |
| where |
| ss_customer_sk = c_customer_sk |
| and cnt between 15 and 20 |
| order by |
| c_last_name, |
| c_first_name, |
| c_salutation, |
| c_preferred_cust_flag desc, |
| cnt, |
| ss_ticket_number; |
| ---- RESULTS |
| 'Abbott','Harriet','Ms.','N',195008,15 |
| 'Acosta','Victor','Mr.','N',156807,15 |
| 'Adams','Jerry','Sir','N',216653,15 |
| 'Adams','Willie','Sir','N',88285,15 |
| 'Alford','Deborah','Miss','N',97678,15 |
| 'Allen','Marty','Sir','N',63646,15 |
| 'Anderson','Cindy','Miss','N',90504,15 |
| 'Anderson','Eloise','Mrs.','Y',59994,16 |
| 'Anderson','Marta','Dr.','N',176320,15 |
| 'Anderson','Martha','Mrs.','N',74295,15 |
| 'Anderson','Norma','Miss','Y',132983,16 |
| 'Anderson','Rosemarie','Mrs.','N',178489,15 |
| 'Andrews','Cindy','Miss','Y',132595,16 |
| 'Andrews','Michael','Sir','N',135694,15 |
| 'Andrews','Robert','Sir','Y',30467,15 |
| 'Appleton','Gary','Dr.','N',58554,16 |
| 'Archibald','Cindy','Miss','Y',87178,16 |
| 'Arredondo','Phyllis','Ms.','Y',226220,16 |
| 'Arsenault','Janet','Mrs.','N',169973,16 |
| 'Ashton','Irma','Mrs.','Y',99233,15 |
| 'Bailey','Lucille','Mrs.','N',2490,15 |
| 'Baker','Erik','Sir','Y',69511,15 |
| 'Barba','William','Sir','Y',102719,15 |
| 'Barnes','John','Dr.','N',74071,15 |
| 'Barnes','Michael','Mr.','N',168802,15 |
| 'Bear','Tommy','Sir','Y',27468,15 |
| 'Beasley','Joshua','Dr.','Y',32731,15 |
| 'Bell','William','Mr.','Y',82227,15 |
| 'Bender','Grover','Dr.','N',152239,15 |
| 'Benedict','Bridget','Dr.','N',16544,15 |
| 'Benson','Mike','Sir','Y',53219,16 |
| 'Berry','Theresa','Ms.','Y',77257,15 |
| 'Bilodeau','Norma','Ms.','Y',136244,15 |
| 'Blake','John','Mr.','N',193896,15 |
| 'Blanchard','Joanne','Dr.','N',5917,15 |
| 'Boles','George','Sir','N',64282,15 |
| 'Bolin','Yolanda','Dr.','N',13057,16 |
| 'Bowden','Kathleen','Ms.','N',106265,15 |
| 'Box','Eric','Dr.','N',79283,16 |
| 'Boyd','Mildred','Miss','N',190083,15 |
| 'Boyer','Betty','Mrs.','Y',171238,16 |
| 'Boyle','Timothy','Dr.','N',21865,16 |
| 'Brandt','James','Sir','Y',60562,15 |
| 'Brantley','Frank','Dr.','N',66867,15 |
| 'Brewer','Lynne','Ms.','N',77584,15 |
| 'Broughton','Doretta','Ms.','Y',206939,16 |
| 'Brower','Donald','Dr.','N',163579,15 |
| 'Brown','David','Mr.','N',162755,16 |
| 'Brown','Frederick','Mr.','N',120037,15 |
| 'Brown','Janette','Dr.','Y',7269,16 |
| 'Brown','Janice','Ms.','Y',138617,15 |
| 'Brown','Raymond','Mr.','Y',212279,15 |
| 'Brown','Roderick','Mr.','N',221290,16 |
| 'Brown','Will','Mr.','Y',147392,15 |
| 'Buck','Andrew','Dr.','N',128839,15 |
| 'Burch','Diana','Mrs.','Y',115522,15 |
| 'Burdette','Ronald','Mr.','Y',118097,15 |
| 'Butcher','Francine','Mrs.','N',112093,15 |
| 'Butcher','Thomas','Mr.','N',213918,15 |
| 'Butler','Amos','Dr.','N',7184,15 |
| 'Butler','Nicole','Dr.','N',214214,16 |
| 'Byrd','Stephanie','Miss','Y',24803,15 |
| 'Byrd','Wanda','Ms.','Y',155385,15 |
| 'Campbell','Gordon','Mr.','N',196090,15 |
| 'Campbell','William','Mr.','N',95665,15 |
| 'Carlson','Gwendolyn','Dr.','Y',88472,15 |
| 'Carpenter','Stephen','Mr.','Y',174519,16 |
| 'Carroll','Frederick','Mr.','Y',56635,15 |
| 'Carter','Cecil','Dr.','Y',34336,16 |
| 'Carter','Eddie','Dr.','N',226103,16 |
| 'Carter','Olga','Mrs.','N',84776,15 |
| 'Casey','Darrell','Sir','N',181470,15 |
| 'Castro','Sandra','Ms.','N',87567,15 |
| 'Chandler','Lisa','Dr.','N',102461,16 |
| 'Chang','Bradley','Sir','Y',53396,15 |
| 'Chang','Erik','Sir','Y',140138,15 |
| 'Chase','Daniel','Dr.','Y',129179,15 |
| 'Cheek','Rebecca','Mrs.','Y',82193,15 |
| 'Chen','Brett','Mr.','N',7880,15 |
| 'Christenson','Steven','Mr.','Y',156157,15 |
| 'Clark','Elisa','Mrs.','Y',234445,15 |
| 'Clark','Elizabeth','Dr.','Y',58831,15 |
| 'Clark','Meredith','Dr.','N',229216,16 |
| 'Clark','Rosemary','Miss','Y',31542,15 |
| 'Clayton','Michael','Mr.','N',69714,16 |
| 'Clemente','Patrick','Sir','Y',179702,15 |
| 'Clifford','Bessie','Dr.','N',61376,16 |
| 'Clifford','John','Sir','Y',12960,15 |
| 'Cochran','Dennis','Sir','Y',94375,15 |
| 'Coker','John','Mr.','N',2730,15 |
| 'Cole','Amanda','Dr.','Y',92994,15 |
| 'Cole','Gretchen','Dr.','N',191039,15 |
| 'Cole','June','Miss','N',206225,16 |
| 'Cole','Melanie','Mrs.','Y',208547,15 |
| 'Coleman','Nancy','Ms.','N',39446,16 |
| 'Collier','NULL','Mr.','Y',179488,15 |
| 'Collins','Patsy','Ms.','N',13775,15 |
| 'Conner','Sondra','Miss','N',191684,15 |
| 'Conrad','Jason','Mr.','N',166289,15 |
| 'Cook','John','Mr.','N',237195,15 |
| 'Cook','NULL','Sir','NULL',81755,15 |
| 'Cope','Felicia','Dr.','Y',195003,15 |
| 'Cordero','Dwight','Sir','Y',147038,15 |
| 'Cota','Jorge','Mr.','N',3324,15 |
| 'Crouch','Roberto','Dr.','Y',160826,15 |
| 'Cruz','Donna','Ms.','N',180864,15 |
| 'Cruz','Tamara','Ms.','N',112086,16 |
| 'Dalton','Dorthea','Dr.','Y',37698,15 |
| 'David','Timothy','Mr.','Y',20342,16 |
| 'Davis','Donya','Miss','N',31118,15 |
| 'Davis','Jess','Sir','Y',197947,15 |
| 'Davis','Sandra','Ms.','N',141249,15 |
| 'Davis','Vickie','Miss','Y',35264,15 |
| 'Davison','Jeffrey','Mr.','Y',81413,16 |
| 'Dejesus','Lorena','Dr.','NULL',157934,15 |
| 'Delacruz','Brenton','Mr.','Y',96016,15 |
| 'Delagarza','John','Mr.','N',62980,15 |
| 'Diaz','Brian','Mr.','N',73210,15 |
| 'Dietrich','Tammy','Dr.','N',114650,15 |
| 'Dorsey','Lisa','Dr.','Y',5587,15 |
| 'Dorsey','Melvin','Mr.','Y',231758,15 |
| 'Dunn','Stephen','Sir','N',32455,15 |
| 'Eason','Mario','Sir','N',174089,15 |
| 'Easton','Christopher','Sir','Y',10691,15 |
| 'Elliot','Mark','Mr.','Y',35782,16 |
| 'Esquivel','Hee','Mrs.','Y',42741,15 |
| 'Evans','April','Dr.','Y',41310,15 |
| 'Faison','Roy','Sir','Y',147757,15 |
| 'Farnsworth','Danny','Mr.','Y',29979,15 |
| 'Ferrell','Roy','Mr.','N',139997,15 |
| 'Ferris','William','Sir','Y',12536,15 |
| 'Fields','Philomena','Dr.','N',217374,15 |
| 'Fife','Terry','Dr.','N',81012,15 |
| 'Finn','Margaret','Dr.','N',207070,15 |
| 'Fitzgerald','Thomas','Mr.','Y',2698,15 |
| 'Floyd','Lillian','Dr.','Y',84374,16 |
| 'Flynn','Rhonda','Miss','N',96322,15 |
| 'Forney','Christopher','Sir','N',175230,15 |
| 'Franklin','Dorothy','Miss','Y',210152,15 |
| 'Franklin','Eileen','Miss','Y',88556,15 |
| 'Franklin','Judy','Ms.','Y',27813,15 |
| 'Freeman','Rayford','Dr.','N',36115,15 |
| 'Freeman','NULL','Mrs.','Y',175123,15 |
| 'Fuqua','Harvey','Mr.','N',130609,16 |
| 'Galindo','Karen','Dr.','N',100437,15 |
| 'Galloway','Betty','Mrs.','Y',10097,15 |
| 'Garcia','Kenny','Dr.','N',197122,16 |
| 'Garrison','Robert','Sir','Y',40421,15 |
| 'Garza','William','Sir','N',43273,15 |
| 'German','Katie','Dr.','N',33536,16 |
| 'Gibbons','Christopher','Sir','Y',237265,16 |
| 'Gibbons','Vivian','Mrs.','Y',95173,16 |
| 'Gibson','Agnes','Miss','N',228161,15 |
| 'Gil','Yvette','Mrs.','Y',86699,15 |
| 'Gill','Joshua','Sir','Y',230910,16 |
| 'Glass','Jorge','Sir','N',137536,15 |
| 'Gomez','Brandon','Sir','Y',160457,15 |
| 'Gonzales','Cindy','Dr.','Y',96495,15 |
| 'Gonzales','Edgar','Sir','N',153714,15 |
| 'Gonzalez','Ruby','Mrs.','Y',228694,15 |
| 'Gordon','Larry','Sir','Y',99782,15 |
| 'Graham','Brian','Mr.','N',13629,15 |
| 'Graham','Jerry','Sir','NULL',152656,15 |
| 'Gray','Jeffery','Mr.','Y',154258,15 |
| 'Grayson','Carolyn','Mrs.','N',69374,16 |
| 'Grayson','Terry','Mr.','N',130480,16 |
| 'Green','Cynthia','Mrs.','Y',141374,15 |
| 'Green','Robert','Mr.','N',73965,15 |
| 'Griffin','Martha','Dr.','N',82841,16 |
| 'Grubbs','Florence','Mrs.','N',47930,15 |
| 'Gulley','Daniel','Sir','Y',37484,16 |
| 'Gutierrez','Ashley','Dr.','N',209948,16 |
| 'Guzman','Mason','Mr.','Y',235019,16 |
| 'Haley','Henry','Sir','Y',141619,15 |
| 'Hall','Roger','Mr.','N',136216,15 |
| 'Hamilton','Alex','Mrs.','N',23084,15 |
| 'Hammonds','Richelle','Dr.','Y',135423,15 |
| 'Hampton','NULL','NULL','N',11567,15 |
| 'Hardy','Inez','Ms.','Y',104878,15 |
| 'Harris','Charles','Dr.','Y',61618,15 |
| 'Harris','Ezekiel','Sir','N',142043,15 |
| 'Harrison','Jennifer','Ms.','Y',63097,15 |
| 'Harrison','Michal','Mr.','Y',209687,15 |
| 'Harrison','Qiana','Dr.','Y',10522,15 |
| 'Hawkins','Clyde','Dr.','Y',236510,15 |
| 'Hayes','Elizabeth','Mrs.','N',213826,15 |
| 'Hayes','Johnnie','Sir','N',57732,15 |
| 'Hayes','William','Sir','Y',223946,15 |
| 'Haynes','Jennifer','Dr.','N',203136,15 |
| 'Haywood','Judy','Mrs.','N',167146,15 |
| 'Hernandez','Paul','Dr.','N',190691,15 |
| 'Hernandez','Sandra','Dr.','Y',14252,16 |
| 'Hewitt','Michelle','Dr.','N',155492,15 |
| 'Hill','Barbara','Ms.','Y',88890,15 |
| 'Hill','Julia','Dr.','N',191695,16 |
| 'Horton','Michelle','Ms.','Y',112716,16 |
| 'Howell','Katherine','Dr.','N',147571,16 |
| 'Huffman','Beverly','Ms.','Y',166660,16 |
| 'Hughes','Martin','Dr.','Y',178631,15 |
| 'Ivey','John','Mr.','N',189224,15 |
| 'Jackman','Ida','Dr.','Y',11753,15 |
| 'Jackson','Kathy','Ms.','N',233945,15 |
| 'Johnson','Lottie','Ms.','N',131031,15 |
| 'Johnson','Olen','Mr.','N',12862,15 |
| 'Johnson','Richard','Dr.','N',52256,15 |
| 'Johnston','Walter','Mr.','Y',219689,15 |
| 'Jones','Austin','Dr.','Y',57009,15 |
| 'Jones','Eleanor','Ms.','N',27477,16 |
| 'Jones','Jarvis','Sir','Y',74474,16 |
| 'Jones','Rebecca','Dr.','Y',187035,16 |
| 'Jones','Richard','Dr.','Y',232872,15 |
| 'Joseph','Ramon','Mr.','N',7856,15 |
| 'Joyce','NULL','Ms.','NULL',154184,16 |
| 'Keaton','Lacey','Mrs.','N',133023,15 |
| 'Keith','Bruce','Dr.','Y',24541,15 |
| 'Kelly','Betty','Dr.','Y',151468,16 |
| 'Kim','Bridget','Mrs.','Y',62861,15 |
| 'King','Thomas','Sir','N',62796,15 |
| 'Kinney','Angelica','Mrs.','N',192978,16 |
| 'Kline','Donald','Mr.','Y',161957,15 |
| 'Knight','Terence','Dr.','N',176372,16 |
| 'Kraus','Roger','Dr.','Y',117604,16 |
| 'Kruse','Jose','Dr.','N',114533,15 |
| 'Lacy','Mina','Miss','N',227155,15 |
| 'Ladner','Lisa','Dr.','Y',213223,15 |
| 'Laird','Mark','Mr.','N',65882,15 |
| 'Lavender','Robert','Sir','Y',3754,15 |
| 'Lawson','Amanda','Ms.','Y',61212,16 |
| 'Lawson','Kelly','Mr.','Y',64975,15 |
| 'Le','Rodney','Dr.','Y',79356,16 |
| 'Leigh','Abraham','Mr.','N',10283,15 |
| 'Lewis','Annie','Ms.','Y',131418,15 |
| 'Lewis','Bradley','Sir','N',182566,16 |
| 'Lewis','Jerry','Mr.','Y',233447,15 |
| 'Light','Robert','Mr.','Y',90021,15 |
| 'Lin','Robert','Dr.','Y',236887,15 |
| 'Lopez','Randee','Miss','N',9979,15 |
| 'Lopez','Theresa','Miss','Y',169110,15 |
| 'Lott','Ronald','Sir','N',79453,15 |
| 'Love','Sean','Mr.','N',196652,15 |
| 'Lowe','Elmer','Sir','N',133003,16 |
| 'Lozano','Charlotte','Mrs.','Y',31661,15 |
| 'Macias','Roger','Sir','N',82746,15 |
| 'Mansfield','Paul','Dr.','Y',5723,15 |
| 'Manuel','Doris','Mrs.','Y',148847,15 |
| 'Marks','Duane','Dr.','Y',34432,15 |
| 'Marsh','Gary','Sir','Y',6580,15 |
| 'Martin','Donald','Dr.','N',238840,16 |
| 'Martin','Steve','Mr.','N',72094,16 |
| 'Mason','Richard','Sir','Y',27500,16 |
| 'Mast','Catalina','Miss','Y',178574,15 |
| 'Matos','Josephine','Ms.','N',128283,16 |
| 'Maxey','Sharon','Ms.','N',74649,16 |
| 'Mccallister','Andrew','Ms.','Y',122178,15 |
| 'Mccloud','Nicholas','Mr.','Y',28001,15 |
| 'Mcconnell','Scott','Mr.','Y',78305,15 |
| 'Mccormick','Joanne','Ms.','N',236985,15 |
| 'Mcdaniel','Brian','Sir','N',217760,15 |
| 'Mcdonald','Araceli','Ms.','Y',121343,15 |
| 'Mcewen','Barbara','Mrs.','N',179491,15 |
| 'Mckenzie','Ana','Ms.','N',201062,16 |
| 'Mcnamara','Joann','Mrs.','Y',229870,15 |
| 'Mcswain','Virgil','Mr.','N',71937,16 |
| 'Melton','Monique','Ms.','Y',177605,15 |
| 'Miller','Brian','Dr.','N',203465,16 |
| 'Miller','Dennis','Dr.','N',137781,15 |
| 'Miller','Edward','Sir','N',64767,16 |
| 'Miller','Georgia','Ms.','N',40740,16 |
| 'Miller','Karrie','Dr.','N',170750,15 |
| 'Miller','Nancy','Mrs.','N',82671,16 |
| 'Montgomery','Julie','Miss','N',17471,15 |
| 'Moore','Barbara','Dr.','N',69608,15 |
| 'Moore','Jeffrey','Sir','Y',155931,15 |
| 'Moore','Lorena','Mrs.','Y',47752,15 |
| 'Moore','Peggy','Miss','Y',191466,15 |
| 'Morgan','Betty','Dr.','N',90306,15 |
| 'Morgan','Latricia','Mrs.','N',216137,15 |
| 'Morris','John','Dr.','Y',214378,15 |
| 'Morris','Martina','Miss','N',32596,15 |
| 'Morris','Meghan','Mrs.','Y',127565,15 |
| 'Moses','Amy','Dr.','Y',182188,15 |
| 'Moss','Michael','NULL','NULL',137243,15 |
| 'Moultrie','Martin','Dr.','N',215102,15 |
| 'Mulligan','Mark','Sir','Y',184598,16 |
| 'Mullins','Vicki','Dr.','Y',162762,15 |
| 'Murphy','Michael','Sir','Y',210567,15 |
| 'Neeley','Stephanie','Mrs.','N',216299,15 |
| 'Nelson','Everette','Dr.','N',80821,15 |
| 'Nesbitt','Andrew','Miss','N',185257,15 |
| 'Norfleet','Ethel','Miss','N',14366,15 |
| 'Olds','Stephen','Dr.','N',206275,16 |
| 'Olson','David','Dr.','Y',87821,16 |
| 'Oneill','Thomas','Mr.','N',188154,15 |
| 'Oneill','Thomas','Mr.','N',93473,16 |
| 'Osborn','Lena','Miss','Y',226949,16 |
| 'Outlaw','Dennis','Sir','N',115215,16 |
| 'Owens','Terry','Dr.','N',144931,15 |
| 'Page','Elizabeth','Ms.','N',146879,15 |
| 'Page','James','Dr.','Y',214208,16 |
| 'Palacios','Amber','Dr.','Y',225723,15 |
| 'Palmer','Debbie','Dr.','Y',121860,15 |
| 'Park','Jerry','Dr.','N',73028,15 |
| 'Peace','Carlos','Sir','N',203823,15 |
| 'Perez','Harold','Mr.','Y',6311,15 |
| 'Perez','Sheri','Ms.','N',157585,15 |
| 'Perry','Sarah','Ms.','N',100885,15 |
| 'Perry','Valeria','Mrs.','N',64861,15 |
| 'Phelps','Marco','Dr.','Y',86494,16 |
| 'Powell','Robert','Sir','Y',185862,15 |
| 'Price','Florence','Ms.','Y',17220,15 |
| 'Price','Gloria','Mrs.','Y',22568,15 |
| 'Price','Marguerite','Mrs.','N',134265,16 |
| 'Price','Marie','Ms.','N',88963,15 |
| 'Price','Paul','Sir','N',103985,16 |
| 'Price','Reginald','Sir','Y',123793,15 |
| 'Price','NULL','Sir','N',55817,15 |
| 'Pridgen','Hans','Dr.','N',207216,15 |
| 'Ramirez','Lee','Sir','N',234584,15 |
| 'Ramos','David','Dr.','Y',189463,16 |
| 'Reece','Jimmy','Sir','N',166493,16 |
| 'Reyes','Frank','NULL','NULL',84620,15 |
| 'Reyna','Rod','Sir','N',46248,16 |
| 'Reynolds','Oscar','Sir','Y',222749,15 |
| 'Richardson','Alice','Ms.','N',43255,16 |
| 'Riddle','John','Sir','Y',83916,15 |
| 'Riddle','Marcelino','Dr.','N',60749,15 |
| 'Rivera','Kate','Ms.','Y',204524,15 |
| 'Robb','Laura','Miss','NULL',173667,15 |
| 'Roberts','Candice','Dr.','Y',111855,16 |
| 'Roberts','Dorothy','Ms.','N',183154,15 |
| 'Roberts','Jennifer','Miss','Y',141296,15 |
| 'Robinson','Gary','Mr.','Y',87081,15 |
| 'Robinson','Sara','Mrs.','N',190406,15 |
| 'Roldan','Dorothy','Mrs.','N',9370,15 |
| 'Roman','Jimmie','Dr.','Y',221049,15 |
| 'Ross','Rachael','Mrs.','N',106042,16 |
| 'Ross','Robert','Mr.','Y',165295,15 |
| 'Russ','Amber','Mrs.','N',225981,15 |
| 'Russell','Larry','Dr.','Y',15209,16 |
| 'Russell','Mark','Dr.','N',126453,15 |
| 'Sacco','Brian','Sir','N',124398,16 |
| 'Saddler','Robert','Mr.','Y',74571,15 |
| 'Salinas','Kenneth','Dr.','Y',167446,15 |
| 'Salter','Antonio','Miss','N',27497,16 |
| 'Sanders','Dustin','Mr.','N',20319,15 |
| 'Sandoval','Vincent','Mr.','N',140438,16 |
| 'Sanford','Ronald','Sir','N',211947,15 |
| 'Saunders','Mae','Miss','N',108927,15 |
| 'Scott','Adam','Mrs.','N',13944,15 |
| 'Scott','Ethel','Dr.','N',112707,15 |
| 'Scott','Michael','Mr.','Y',104162,15 |
| 'Self','Harry','Sir','Y',102208,16 |
| 'Shaffer','Richard','Dr.','N',190775,16 |
| 'Shuler','Joseph','Sir','N',57224,16 |
| 'Sims','Fern','Dr.','Y',175233,15 |
| 'Sims','John','Dr.','Y',113923,15 |
| 'Smalls','Celeste','Ms.','Y',168837,15 |
| 'Smith','Dalene','Ms.','Y',143125,16 |
| 'Smith','Herbert','Dr.','Y',238646,15 |
| 'Smith','John','Mr.','N',93525,16 |
| 'Smith','Marion','Mr.','Y',65393,15 |
| 'Smith','Ralph','Sir','N',87132,16 |
| 'Smith','Terry','Dr.','Y',16945,15 |
| 'Smith','Toni','Miss','N',50011,15 |
| 'Smith','Wendell','Sir','N',85496,15 |
| 'Soares','Sally','Ms.','Y',203554,16 |
| 'Sparks','Michael','Mr.','Y',23696,15 |
| 'Spears','Edith','Ms.','Y',223566,15 |
| 'Spencer','Alfred','Mr.','Y',159308,15 |
| 'Spencer','Teri','Mrs.','N',28551,16 |
| 'Stafford','Jerry','Mr.','Y',230470,15 |
| 'Stamper','Rebekah','Dr.','N',235329,15 |
| 'Stephens','Donna','Ms.','N',151844,15 |
| 'Stevens','Mattie','Ms.','N',202640,15 |
| 'Stevens','Micheal','Dr.','Y',38659,16 |
| 'Stewart','Amanda','Mrs.','Y',145235,15 |
| 'Stewart','Gilbert','Mr.','Y',217862,15 |
| 'Stewart','Kendra','Mrs.','Y',16423,15 |
| 'Stewart','Pamela','Mrs.','Y',88160,16 |
| 'Straub','Lowell','Dr.','Y',215956,16 |
| 'Street','Lee','Mr.','N',171013,15 |
| 'Sullivan','Amy','Dr.','N',166225,15 |
| 'Swain','Laura','Ms.','Y',36774,16 |
| 'Swisher','Brian','Mr.','Y',53341,15 |
| 'Taylor','Arlene','Dr.','Y',71934,15 |
| 'Taylor','Jacqueline','Mrs.','Y',89977,16 |
| 'Taylor','Karen','Dr.','N',29777,15 |
| 'Taylor','Robert','Dr.','N',37700,15 |
| 'Thomas','Barbara','Dr.','N',172596,15 |
| 'Thomas','Christel','Dr.','Y',34579,15 |
| 'Thomas','Jeffrey','Dr.','Y',115846,15 |
| 'Thomas','Nichole','Miss','N',200721,16 |
| 'Thomas','Rebecca','Mrs.','N',80953,15 |
| 'Thompson','Brenda','Dr.','N',171735,15 |
| 'Thompson','Melissa','Dr.','N',162831,15 |
| 'Tidwell','Phyllis','NULL','NULL',234037,16 |
| 'Tilley','Jane','Mrs.','Y',45378,15 |
| 'Tinsley','Charlie','Dr.','N',23881,16 |
| 'Tolbert','Emily','Miss','Y',40132,15 |
| 'Tompkins','Charlotte','NULL','NULL',197857,15 |
| 'Torres','Jason','Dr.','N',224,16 |
| 'Torres','Roberta','Ms.','N',29436,15 |
| 'Townsend','Michelle','Mrs.','N',39872,15 |
| 'Turner','Kerry','Dr.','Y',23710,16 |
| 'Turner','Marjorie','Mrs.','N',65289,15 |
| 'Valenzuela','Bryan','Sir','Y',221858,16 |
| 'Vance','Josefina','Mrs.','N',147148,15 |
| 'Vargas','Charles','Dr.','Y',79536,15 |
| 'Vogel','Leroy','Sir','Y',29032,15 |
| 'Walker','Jim','Sir','N',46947,15 |
| 'Walker','Jose','Sir','Y',189670,16 |
| 'Walker','Richard','Sir','NULL',226475,15 |
| 'Wall','Russell','Sir','N',17231,16 |
| 'Wallace','Joseph','Sir','N',27193,15 |
| 'Walsh','Javier','Sir','Y',211987,16 |
| 'Warren','Brian','Dr.','N',15877,15 |
| 'Watson','Tina','Ms.','Y',120030,16 |
| 'Webb','Gloria','Ms.','N',65663,15 |
| 'Welch','Pauline','Mrs.','Y',47529,15 |
| 'West','Carman','Ms.','NULL',237594,15 |
| 'West','Rachel','Dr.','Y',138384,15 |
| 'Wetzel','Bebe','Dr.','N',82518,15 |
| 'White','Diane','Dr.','Y',82960,16 |
| 'White','Johnny','Dr.','N',204026,16 |
| 'Whitehead','Magan','Dr.','N',192159,16 |
| 'Wiggins','Kermit','Sir','N',112643,15 |
| 'Wilbur','Terry','Sir','N',200312,15 |
| 'Williams','Archie','Mr.','N',113007,15 |
| 'Williams','Karen','Ms.','Y',140802,15 |
| 'Williams','Scott','NULL','NULL',136844,16 |
| 'Willis','Amber','Ms.','N',53815,15 |
| 'Willis','Michael','Sir','Y',207326,15 |
| 'Wilson','Charles','Mr.','Y',60,15 |
| 'Wood','Mark','Dr.','N',4376,15 |
| 'Woody','Philip','Mr.','N',211173,16 |
| 'Wright','Amanda','NULL','Y',105395,15 |
| 'Yates','Kimberly','Ms.','Y',220849,15 |
| 'NULL','Grace','NULL','NULL',147095,16 |
| 'NULL','Joshua','Sir','N',108357,15 |
| 'NULL','Judy','Dr.','NULL',234350,16 |
| 'NULL','Roy','NULL','NULL',200033,15 |
| 'NULL','NULL','Mr.','Y',214003,15 |
| 'NULL','NULL','Ms.','NULL',54536,16 |
| 'NULL','NULL','NULL','NULL',151297,15 |
| 'NULL','NULL','NULL','NULL',148695,16 |
| 'NULL','NULL','NULL','Y',16278,15 |
| 'NULL','NULL','NULL','Y',146557,16 |
| 'NULL','NULL','NULL','N',55640,15 |
| 'NULL','NULL','NULL','N',58614,15 |
| 'NULL','NULL','NULL','N',96514,15 |
| 'NULL','NULL','NULL','N',220211,15 |
| ---- TYPES |
| STRING, STRING, STRING, STRING, BIGINT, BIGINT |
| ==== |