====
---- 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
====