104 taos ct dauphin island al 36528

In this assignment, you are supplied a simple dataset for which you will write SQL queries. You will be using the well-known MySQL RDBMS for this task.

You are provided a MySQL data file containing data about a paints business based in United States. It contains data about the customers, invoices, employees, products and vendors. Import this file into your MySQL installation by following the instructions on Interact site.

Click here to download Prime Paints .sql data file. For your convenience an ERD is also provided so that you can better understand the database structure. Some column names are ambiguous, their description is provided below:

· Prod_SKU - A unique identifier for every single product in stock.

· Prod_Min - A minimum theshold level for a product. When stock falls below that level, it must be reordred.

· Prod_QOH - Quantity on hand for the given product.

· Cust_Balance - The amount owed by a customer. It is not the same as total of their invoices.

· Sal_From and Sal_End - Dates indicating a pay period.

· Sal_Amount - Salary paid to the employee in the given pay period

· Emp_Comm - Rate of commission for some employees.

Write and execute SQL statements to complete each of the following tasks. Copy your SQL statements into the assignment document. Secondly, include the screenshots of results obtained by executing those statements on the DBMS. Typing the results of SQL statements is NOT acceptable.

1. List the names and street addresses of all vendors based in states of Michigan or Ohio. Sort the list by city name.

2. Find total number of stock items the company have in their warehouse.

3. Find out the duration (number of days) for which we there are records of sale data. Display the earliest date, latest date and the period between two.

4. Display the first name and contact details (email, phone) of all 'product specialists' who work in Marketing.

5. Find the employee number, full name and hire date of oldest staff member.

6. Find the date(s) with highest amount of sales. Also display the corresponding total sale amount.

7. List all brand names and the total dollar amount of sales for each brand. Sort the list by descending order of brand sales.

8. Find highest paying customers (according to their invoice totals) and list their names along with the city and state they belong to.

9. Find out the total of salaries paid out by all departments during the month of June 2017. Sort the list by department name.

10. For the year 2015, get a list of all professions and their the average salary. Profession is identified employee title. Average must be displayed with 2 decimal places. Sort the list by highest paid jobs at the top.

[1.5 marks × 10]

For some questions that require date and time calculations, please refer to MySQL documentation to see the available functions.

RATIONALE

back to top

This assessment task will assess the following learning outcome/s:

· be able to use complex SQL commands to query a database.

MARKING CRITERIA AND STANDARDS

back to top

The marking criteria for this assignment is:

Criteria

HD

DI

CR

PS

be able to use complex SQL commands to query a database.

SQL syntax returns all attributes that meet the business requirement from the tables that hold the data and applies the correct restrictions to retrieve the required information.

SQL syntax returns all attributes that meet the business requirement from the tables that hold the data with minor omissions and applies appropriate restrictions to retrieve the required information.

SQL syntax returns key attributes that meet the business requirement from the tables that hold the data and applies relevant restrictions to retrieve the required informationn

SQL syntax returns key attributes that meet the business requirement from the tables that hold the data but the restrictions applied to retrieve the required information contain minor errors.

PRESENTATION

back to top

Please prepare and submit a single Word document containing your SQL queries and result screenshots.

REQUIREMENTS

back to top

Only MySQL RDMBS must be used for this exercise. You may use a graphical front end like MySQL Workbench for executing queries. Instruction videos for this task will be provided on Interact site.

DROP DATABASE IF EXISTS `prime_paints`; CREATE DATABASE IF NOT EXISTS `prime_paints`; USE `prime_paints`; /* Credits: Database Systems 13e, Coronel/Morris */ DROP TABLE IF EXISTS `brand`; CREATE TABLE IF NOT EXISTS `brand` ( `BRAND_ID` decimal(4,0) NOT NULL, `BRAND_NAME` varchar(100) NOT NULL, `BRAND_TYPE` varchar(20) DEFAULT NULL, PRIMARY KEY (`BRAND_ID`) ); DELETE FROM `brand`; INSERT INTO `brand` (`BRAND_ID`, `BRAND_NAME`, `BRAND_TYPE`) VALUES (23, 'FORESTERS BEST', 'VALUE'), (24, 'REGAL HOME', 'VALUE'), (25, 'STUTTENFURST', 'CONTRACTOR'), (26, 'HOMESTEADER FINEST', 'PREMIUM'), (27, 'HOME COMFORT', 'CONTRACTOR'), (28, 'OLDE TYME QUALITY', 'CONTRACTOR'), (29, 'BUSTERS', 'VALUE'), (30, 'LONG HAUL', 'CONTRACTOR'), (31, 'VALU-MATTE', 'VALUE'), (32, 'YOUR HOME HELPER', 'VALUE'), (33, 'BINDER PRIME', 'PREMIUM'), (34, 'PRIME OF LIFE', 'VALUE'), (35, 'LE MODE', 'PREMIUM'); DROP TABLE IF EXISTS `customer`; CREATE TABLE IF NOT EXISTS `customer` ( `CUST_CODE` decimal(38,0) NOT NULL, `CUST_FNAME` varchar(20) DEFAULT NULL, `CUST_LNAME` varchar(20) DEFAULT NULL, `CUST_STREET` varchar(70) DEFAULT NULL, `CUST_CITY` varchar(50) DEFAULT NULL, `CUST_STATE` char(2) DEFAULT NULL, `CUST_ZIP` char(5) DEFAULT NULL, `CUST_BALANCE` decimal(8,2) DEFAULT NULL, PRIMARY KEY (`CUST_CODE`) ); DELETE FROM `customer`; INSERT INTO `customer` (`CUST_CODE`, `CUST_FNAME`, `CUST_LNAME`, `CUST_STREET`, `CUST_CITY`, `CUST_STATE`, `CUST_ZIP`, `CUST_BALANCE`) VALUES (86, 'RUBY', 'HUDSON', '1013 SNOWLINE DRIVE', 'Fayetteville', 'NC', '28305', 1482.35), (87, 'MICHEAL', 'KIRKLAND', '1027 POLLOCK DRIVE', 'Greenback', 'TN', '37742', 642.45), (88, 'LINO', 'VIGIL', '1201 BARNES AVENUE', 'Alquina', 'IN', '47331', 1329.78), (89, 'MONICA', 'CANTRELL', '697 ADAK CIRCLE', 'Loachapoka', 'AL', '36865', 1255.46), (90, 'HELEN', 'GOLDMAN', '1823 HORIZON STREET', 'Catawba Heights', 'NC', '28012', 935.50), (91, 'ALEXANDRA', 'PENNINGTON', '481 CHALLENGER CIRCLE', 'Aurora', 'IN', '47001', 508.86), (92, 'CARLENE', 'GONZALEZ', '1162 CAMPBELL CREEK ROAD', 'Escanaba', 'MI', '49829', 1989.00), (93, 'CIARA', 'BASSETT', '1977 SEAWOLF DRIVE', 'Hope', 'ME', '04847', 1045.64), (94, 'DOMINICK', 'PHELPS', '62 EAST 25TH COURT', 'Upton', 'PA', '17225', 524.50), (95, 'WILMA', 'DUNLAP', '1575 KING WAY DRIVE', 'Bovina Center', 'NY', '13740', 2602.70), (96, 'ROLANDA', 'TRUJILLO', '1415 AUDUBON DRIVE', 'Calverton', 'NY', '11933', 1636.82), (97, 'ERWIN', 'ANDERSON', '884 PLEASANT DRIVE', 'Kingston', 'RI', '02881', 2895.49), (98, 'VALENTIN', 'MARINO', '1377 RUSHWOOD CIRCLE', 'White Plains', 'NY', '10629', 448.10), (99, 'MINERVA', 'VENTURA', '582 WINGATE CIRCLE', 'West Medford', 'MA', '02156', 1818.09), (100, 'VELDA', 'NAVARRO', '145 CRESCENT DRIVE', 'Tampa', 'FL', '33681', 389.63), (101, 'LEONORA', 'FARRELL', '2 EAST DOWLING ROAD', 'Reese', 'NC', '28692', 2949.67), (102, 'EVA', 'KAISER', '1084 LUNAR CIRCLE', 'Queen', 'PA', '16670', 1233.12), (103, 'CORRINA', 'GIFFORD', '1651 HIGHTOWER ROAD', 'Hampden', 'WV', '25623', 2122.07), (104, 'THAD', 'RUIZ', '966 VALARIAN STREET', 'Pine', 'NY', '12203', 495.41), (105, 'FRANCIS', 'TRUJILLO', '1921 WEST 74TH AVENUE', 'Neelyton', 'PA', '17239', 2019.38), (106, 'MELONIE', 'JIMENEZ', '848 DOWNEY FINCH LANE', 'East Monkton', 'VT', '05443', 1265.16), (107, 'RAY', 'KEYES', '303 TEEKOANA CIRCLE', 'Cliftonville', 'MS', '39739', 589.23), (108, 'GONZALO', 'WHITNEY', '1567 WALLACE MOUNTAIN ROAD', 'Crescent Beach', 'FL', '34242', 1123.40), (109, 'SAL', 'STRATTON', '985 OSTOVIA CIRCLE', 'Harts Store', 'NC', '27022', 0.00), (110, 'CRISTINA', 'SOSA', '904 PINNACLE CIRCLE', 'Cran Nav Dpo', 'IN', '47522', 0.00), (111, 'JOSE', 'CASE', '640 WEST 71ST COURT', 'Wyano', 'PA', '15695', 0.00), (112, 'LAN', 'NICHOLS', '367 LAKEVIEW DRIVE', 'Pittsburgh', 'PA', '15262', 4760.14), (113, 'KORY', 'GOULD', '1949 HUMPHREY DRIVE', 'Cochecton', 'NY', '12726', 657.57), (114, 'MIRIAN', 'DIAMOND', '1432 POTTER GLEN CIRCLE', 'Nauvoo', 'PA', '16938', 0.00), (115, 'STACIE', 'SCHMITZ', '704 WOODLAND DRIVE', 'Little Hocking', 'OH', '45742', 1989.53), (116, 'STEPHAINE', 'MOSLEY', '1372 LOREN CIRCLE', 'Saint Paris', 'OH', '43072', 749.61), (117, 'KARON', 'MATA', '1073 FERN CIRCLE', 'Bay State', 'MA', '01060', 3009.63), (118, 'JESSE', 'HICKS', '614 SOUTH AIRPARK DRIVE', 'Bay Head', 'NJ', '08742', 3058.55), (119, 'MATTIE', 'VERNON', '548 FALLING WATER DRIVE', 'Simsbury', 'CT', '06092', 1615.78), (120, 'BRADLEY', 'BRYAN', '1153 TOBUK CIRCLE', 'Philadelphia', 'PA', '19116', 1230.92), (121, 'PETER', 'SMALL', '1904 GLENN NB OFF MULDOON SB RAMP', 'Methodist Mem Home', 'IN', '46792', 341.55), (122, 'JANNETTE', 'MCCARTHY', '1450 ORCA PLACE', 'Millwood', 'GA', '31552', 1811.67), (123, 'SHANTELL', 'DRAKE', '1901 STERLING WAY', 'Quaker City', 'OH', '43773', 299.78), (124, 'LINDSAY', 'BARRERA', '496 DEGAN STREET', 'Gray', 'KY', '40734', 0.00), (125, 'FLORENTINO', 'ROJAS', '1211 JESSE LEE COURT', 'Merrill', 'NY', '12955', 81.57), (126, 'DOLLY', 'MICHAEL', '1359 SWEETWATER CIRCLE', 'Borden Shaft', 'MD', '21532', 3341.80), (127, 'CORRINA', 'DENNIS', '1021 CARNABY WAY', 'Hartleyville', 'IN', '47421', 1039.74), (128, 'REGGIE', 'CAREY', '644 INNES CIRCLE', 'Harrisburg', 'PA', '17128', 2050.86), (129, 'MANUEL', 'CARROLL', '1768 ANCHOR PARK CIRCLE', 'Williston Park', 'NY', '11596', 866.75), (130, 'REYES', 'MANUEL', '1180 NIKITA DRIVE', 'Mount Ayr', 'IN', '47964', 1945.15), (131, 'SAL', 'WHALEY', '1715 ADAK CIRCLE', 'Montezuma', 'GA', '31063', 1397.44), (132, 'JANIS', 'DUBOIS', '563 BENTREE CIRCLE', 'Reading', 'PA', '19606', 2015.62), (133, 'RASHIDA', 'MEDINA', '1440 ORCA STREET', 'Parks Crossroads', 'NC', '27316', 0.00), (134, 'LES', 'SOLOMON', '1815 BIRCHBARK AVENUE', 'Huntington', 'WV', '25708', 2442.72), (135, 'CHRISTINE', 'CAMACHO', '885 KILKERRY CIRCLE', 'Winding Gulf', 'WV', '25908', 1053.95), (136, 'SID', 'WELSH', '1932 CRISWELL CIRCLE', 'Edenton', 'NC', '27932', 2256.41), (137, 'CONNIE', 'VELASQUEZ', '1302 NORMANSHIRE COURT', 'Butlerville', 'IN', '47223', 604.69), (138, 'MALIK', 'MORELAND', '1807 FOREST PARK DRIVE', 'Foxborough', 'MA', '02035', 1339.61), (139, 'LAVINA', 'CORNELL', '137 BRIAR LOOP', 'New York', 'NY', '10130', 3099.10), (140, 'CHRISTOPER', 'OAKES', '1719 NORMANSHIRE COURT', 'Greensboro', 'GA', '30642', 0.00), (141, 'ART', 'ALVARADO', '603 FINE ARTS LANE', 'Baltimore', 'MD', '21214', 780.09), (142, 'DIAN', 'DUKE', '1861 BRENDL WAY', 'Millers Tavern', 'VA', '23115', 0.00), (143, 'MOHAMMED', 'RANKIN', '13 LINDA JO CIRCLE', 'Fernandina Beach', 'FL', '32035', 810.87), (144, 'FRANCESCO', 'GOOD', '1894 MOUNT KILIAK CIRCLE', 'Sea Bright', 'NJ', '07760', 0.00), (145, 'GEORGIANNA', 'GIBBONS', '55 GENEVA PLACE', 'Independence', 'WV', '26374', 0.00), (146, 'JULIA', 'GREENBERG', '1416 TALL SPRUCE DRIVE', 'Silver Spring', 'MD', '20902', 964.50), (147, 'ZACHARIAH', 'CORREA', '261 FISHER DRIVE', 'Bear Branch', 'KY', '41714', 1383.62), (148, 'MAYA', 'ELLIOT', '1991 OAK KNOLL DRIVE', 'Porter', 'PA', '17980', 2421.49), (149, 'LENARD', 'FARR', '1311 CAPTAIN COOK DRIVE', 'Leetonia', 'PA', '17727', 0.00), (150, 'AMY', 'CHO', '1540 MARGE COURT', 'Paul', 'MS', '38920', 997.41), (151, 'MARGUERITE', 'PUTNAM', '427 SAN ROBERTO AVENUE', 'Cornish', 'NH', '03745', 1009.50), (152, 'LISETTE', 'WHITTAKER', '339 NORTHPARK DRIVE', 'Montgomery', 'AL', '36197', 3322.63), (153, 'JEREMY', 'TOBIN', '46 BARBOA CIRCLE', 'Walkertown', 'KY', '41701', 525.22), (154, 'DORENE', 'WARD', '1363 HEIDE DRIVE', 'Panola', 'SC', '29125', 1326.23), (155, 'MARANDA', 'HINKLE', '301 VALARIAN STREET', 'Lakin', 'WV', '25250', 0.00), (156, 'JONAS', 'BARRERA', '246 CARLINE CIRCLE', 'Princess House', 'NC', '27094', 602.18), (157, 'ROSALINE', 'BENSON', '1590 NANTUCKET LOOP', 'Hancock', 'NH', '03449', 1708.86), (158, 'SHANELL', 'KOEHLER', '1051 PLATSEK DRIVE', 'Bayside Beach', 'MD', '21122', 905.78), (159, 'GRACE', 'SALTER', '612 LORI DRIVE', 'Austerlitz', 'NY', '12017', 3667.46), (160, 'JUDI', 'FISHER', '1421 WELLSLEY COURT', 'Columbia', 'PA', '17512', 0.00), (161, 'HORTENCIA', 'HINKLE', '1762 KNIK AVENUE', 'Dayton', 'OH', '45454', 837.11), (162, 'LOUISA', 'REAGAN', '784 LITTLE CAPE CIRCLE', 'West Neck', 'NY', '11743', 1221.04), (163, 'MALISSA', 'ACEVEDO', '159 BAXTER TERRACE CIRCLE', 'Britinay', 'MD', '21234', 839.09), (164, 'MERLE', 'GUNTER', '355 SEWARD SB OFF DIMOND RAMP', 'Lake Buena Vista', 'FL', '32830', 1325.97), (165, 'MOHAMED', 'RAMSEY', '1958 IRIS STREET', 'Lafayette', 'VA', '24087', 459.57), (166, 'EARTHA', 'MONROE', '1942 REVILLA CIRCLE', 'Centreville', 'MD', '21617', 1136.24), (167, 'EVETTE', 'PERRY', '986 LAMPERT CIRCLE', 'Capitol', 'VA', '23207', 124.75), (168, 'WINIFRED', 'WOODWARD', '594 QUEST CIRCLE', 'Prompton', 'PA', '18456', 2735.75), (169, 'ROSS', 'LANG', '1991 EASTWIND COURT', 'Higdon', 'AL', '35979', 1223.50), (170, 'WILBER', 'MURPHY', '901 GIDDEON CIRCLE', 'East Calais', 'VT', '05640', 3139.06), (171, 'COREY', 'BURKETT', '873 EAST 48TH AVENUE', 'Asher Glade', 'MD', '21531', 1258.93), (172, 'DARREL', 'DWYER', '1914 GLACIER LOOP ROAD', 'Savannah', 'GA', '31401', 15.28), (173, 'INGRID', 'HARDY', '479 WALDORF WOODS DRIVE', 'Enka Village', 'NC', '28728', 3509.31), (174, 'DANIELA', 'MOON', '1181 TOLSONA CIRCLE', 'Riley', 'IN', '47871', 684.82), (175, 'DORCAS', 'DUNLAP', '1157 BOWEN CIRCLE', 'Baton', 'NC', '28630', 1333.64), (176, 'TRENTON', 'WINN', '251 KIRBY PLACE', 'Mausdale', 'PA', '17821', 0.00), (177, 'IGNACIO', 'HAGAN', '1704 KALGIN STREET', 'Youngstown', 'OH', '44599', 0.00), (178, 'RHONDA', 'STROUD', '95 SNOWBIRD DRIVE', 'Pgh', 'PA', '15204', 0.00), (179, 'SEAN', 'MAYBERRY', '943 WHITE BIRCH LANE', 'Toledo', 'OH', '43603', 3411.90), (180, 'KASSANDRA', 'OWENS', '1173 SKOOKUM ROAD', 'Laurel Hollow', 'NY', '11724', 895.56), (181, 'RICH', 'COKER', '1156 RIDGELAKE CIRCLE', 'Fork', 'SC', '29543', 0.00), (182, 'NILA', 'VALENCIA', '1709 CAMAI CIRCLE', 'Cold Spring Highland Heights', 'KY', '41076', 394.39), (183, 'AURORA', 'QUINONES', '869 MORNING DRIVE', 'Putnam', 'VA', '24260', 691.34), (184, 'DONG', 'MACIAS', '265 SUNNY CIRCLE', 'Allred', 'TN', '38542', 443.37), (185, 'IRVIN', 'SIZEMORE', '1193 CHENA AVENUE', 'Rockville Center', 'NY', '11571', 3312.59), (186, 'CARLTON', 'ROLAND', '1067 CHUGIAK DRIVE', 'Audubon', 'NJ', '08106', 1672.70), (187, 'DOTTIE', 'SEAY', '1311 FALLOW CIRCLE', 'Vine Grove', 'KY', '40175', 0.00), (188, 'LUANNE', 'GOODWIN', '293 KIANA AVENUE', 'Pinegrove', 'AL', '36507', 1967.38), (189, 'DELFINA', 'MCWILLIAMS', '1453 JESTERS CIRCLE', 'Newton', 'MA', '02195', 381.77), (190, 'DELMER', 'GRUBBS', '1497 KING ARTHUR CIRCLE', 'Silver Spring', 'MD', '20908', 383.81), (191, 'SHIRLEY', 'SPRAGUE', '621 BAIRD CIRCLE', 'Leicester', 'NC', '28748', 1233.64), (192, 'PHILIP', 'GOFF', '1683 GLENKERRY CIRCLE', 'Hinmans Corners', 'NY', '13905', 1401.09), (193, 'LAVON', 'CALHOUN', '4 KIRK AVENUE', 'Wissinoming', 'PA', '19135', 0.00), (194, 'JORGE', 'MILLER', '1998 EAST PRINCE OF PEACE DRIVE', 'Brooklyn', 'NY', '11230', 1269.96), (195, 'SHERRYL', 'KEENAN', '442 DOLLY AVENUE', 'Wallis Run', 'PA', '17771', 0.00), (196, 'DULCE', 'RICHTER', '45 CRETE STREET', 'Alexandria', 'VA', '22306', 645.52), (197, 'XAVIER', 'CARDENAS', '1756 GILL WAY', 'Colesville', 'MD', '20914', 3737.90), (198, 'IOLA', 'ALEXANDER', '859 RIL WAY', 'Clayton', 'MI', '49235', 1215.58), (199, 'SHERMAN', 'OTT', '351 REEF PLACE', 'Sacandaga', 'NY', '12134', 1096.65), (200, 'ANITA', 'CONKLIN', '1044 CORAL REEF PLACE', 'Newton', 'MA', '02195', 1098.52), (201, 'IMELDA', 'FIGUEROA', '1413 GALATEA DRIVE', 'Mccordsville', 'IN', '46055', 1525.10), (202, 'SELINA', 'TANNER', '1352 ATKINSON DRIVE', 'Largo', 'FL', '34649', 1111.92), (203, 'NICKOLAS', 'STACY', '1916 REGINA CIRCLE', 'South Royalston', 'MA', '01331', 915.36), (204, 'TITUS', 'MCCLURE', '439 EMERALD DRIVE', 'Diamond', 'NY', '13659', 202.06), (205, 'VERA', 'CALLAHAN', '797 NORTHERN RAVEN DRIVE', 'Apple Valley', 'OH', '43028', 839.70), (206, 'DENNY', 'CHANDLER', '547 DIMOND D CIRCLE', 'Smithfield', 'WV', '26437', 567.85), (207, 'MARILYN', 'SMALLWOOD', '1169 MEADOW STREET', 'Old Orchard', 'MD', '21228', 2939.47), (208, 'VILMA', 'DENNY', '1520 ABBOTT ROAD', 'Green Lane', 'PA', '18054', 0.00), (209, 'SIDNEY', 'CARR', '570 CANTERBURY WAY', 'Wallingford', 'CT', '06493', 1990.51), (210, 'JANNETTE', 'HARMON', '620 KILOANA CIRCLE', 'Cinda', 'KY', '41728', 0.00), (211, 'GERALD', 'CAUDILL', '1622 NORTH BLISS STREET', 'Oswegatchie', 'NY', '13670', 0.00), (212, 'HANNAH', 'JARRETT', '1589 WEST 43RD AVENUE', 'Twin Branch', 'WV', '24889', 0.00), (213, 'SAMMY', 'GALLAGHER', '206 EAGLE STREET', 'Clearwater', 'SC', '29822', 1326.92), (214, 'ROSEANN', 'THORPE', '472 OXBOW CIRCLE', 'Bangor', 'PA', '18010', 0.00), (215, 'CHARMAINE', 'BRYAN', '1181 LAURENCE COURT', 'Lake City', 'GA', '30260', 3453.84), (216, 'CATHI', 'PUCKETT', '654 KALKA CIRCLE', 'Laurel Bay', 'SC', '29902', 675.43), (217, 'TYRON', 'HOLLINGSWORTH', '1863 TRAIL STREET', 'Alafaya', 'FL', '32834', 1029.40), (218, 'LUPE', 'SANTANA', '1292 WEST 70TH PLACE', 'Phenix City', 'AL', '36867', 1355.29), (219, 'CATHI', 'WHITEHEAD', '760 WOODCLIFF DRIVE', 'Huntsville', 'AL', '35893', 259.61), (220, 'ABRAHAM', 'PLATT', '1859 GINGER LEE DRIVE', 'Sharpes', 'FL', '32959', 2187.26), (221, 'DALTON', 'STAPLES', '673 SUGAR CIRCLE', 'New Lancaster', 'IN', '46036', 282.02), (222, 'DARELL', 'HAGAN', '1066 GINGER LEE DRIVE', 'Hecla', 'PA', '17960', 795.10), (223, 'ALPHA', 'OSBORN', '1850 W STREET', 'Eldora', 'NJ', '08270', 357.75), (224, 'REID', 'BURNETTE', '486 DICKSON ROAD', 'Knightdale', 'NC', '27545', 0.00), (225, 'CHRISTI', 'CLARK', '546 ANSEL CIRCLE', 'Prompton', 'PA', '18456', 1532.26), (226, 'SHELBY', 'SALAS', '486 SUSITNA VIEW COURT', 'North Tisbury', 'MA', '02568', 0.00), (227, 'KATIE', 'HEARN', '1726 MERE CIRCLE', 'Cabin Creek', 'WV', '25035', 3760.96), (228, 'JAUNITA', 'FOOTE', '58 ATLANTIS AVENUE', 'Pitt', 'PA', '15209', 1282.45), (229, 'ERNESTINE', 'LOZANO', '17 BEN COURT', 'Putnam', 'MD', '21050', 1050.75), (230, 'MARCIE', 'CHILDERS', '936 UNIVERSITY LAKE DRIVE', 'Susan', 'VA', '23163', 1786.51), (231, 'ALYCIA', 'PECK', '680 LINCOLN ELLSWORTH COURT', 'Berkshire', 'MA', '01224', 1163.29), (232, 'HOPE', 'DAVID', '640 CASPER COURT', 'Ludington', 'OH', '43730', 435.80), (233, 'KORI', 'GILMORE', '581 SPRUCE STREET', 'Alna', 'ME', '04535', 0.00), (234, 'PALMER', 'VERA', '1516 HILAND ROAD', 'Jacksonville', 'VT', '05342', 205.25), (235, 'RUBY', 'RANKIN', '1154 CONCORD LANE', 'Ridgeway', 'WV', '25440', 824.79), (236, 'MASON', 'COLE', '56 BIRCH RUN CIRCLE', 'Albany', 'NY', '12244', 0.00), (237, 'HORTENSIA', 'KEYES', '571 MARIA COURT', 'Port Byron', 'NY', '13140', 1118.62), (238, 'ALVIN', 'MCLEOD', '1168 BEULAH CIRCLE', 'Tampa', 'FL', '33674', 1000.86), (239, 'MIMI', 'ONEAL', '1760 DANNY CIRCLE', 'Lanham-Seabrook', 'MD', '20703', 572.15), (240, 'ZONA', 'BARROW', '1944 HIGHLAND RIDGE DRIVE', 'Lugoff', 'SC', '29078', 392.87), (241, 'MOSES', 'LUNSFORD', '185 COLUMBINE PLACE', 'Saltaire', 'NY', '11706', 0.00), (242, 'SHELDON', 'HODGE', '1517 PARKSIDE DRIVE', 'Tionesta', 'PA', '16353', 343.20), (243, 'ISREAL', 'NOLAN', '1677 AURIGA WAY', 'Era', 'OH', '43143', 786.53), (244, 'XIOMARA', 'VASQUEZ', '1962 MORNINGTIDE COURT', 'Jamboree', 'KY', '41536', 677.07), (245, 'SHERRILL', 'YODER', '882 NORM DRIVE', 'Warren', 'OH', '44487', 1914.74), (246, 'CATHARINE', 'ROBLES', '815 CEDRUS CIRCLE', 'Montgomery', 'PA', '17752', 1320.32), (247, 'ISABEL', 'HORN', '1554 MACKAY STREET', 'Montgomery Fy', 'PA', '17074', 333.59), (248, 'ROXANNE', 'CONKLIN', '228 NORTHPARK DRIVE', 'Argo Village', 'NY', '11003', 857.27), (249, 'SAMMIE', 'DAHL', '373 GREY WOLF CIRCLE', 'Showell', 'MD', '21862', 0.00), (250, 'LONA', 'WILLARD', '1521 CLARBERT COURT', 'Ettrick', 'VA', '23803', 284.02), (251, 'CHRISTOPER', 'NGUYEN', '972 KERRY LOOP', 'Copper Harbor', 'MI', '49918', 424.03), (252, 'DANIELLA', 'GREENWOOD', '546 GOLDEN SPRING CIRCLE', 'Christmas', 'MI', '49862', 284.47), (253, 'NUMBERS', 'LOUIS', '812 BUSINESS BOULEVARD', 'Delta', 'PA', '17314', 211.77), (254, 'IRA', 'FERGUSON', '1787 KICHATNA CIRCLE', 'Herold', 'WV', '26601', 838.33), (255, 'CHANDRA', 'WALLER', '266 FOXRIDGE CIRCLE', 'Cleveland', 'OH', '44123', 0.00), (256, 'CRISTAL', 'OBRIEN', '480 KUTCHER DRIVE', 'Arlington', 'VA', '22206', 669.96), (257, 'DARLENE', 'OCONNOR', '80 DICKSON ROAD', 'Union', 'OH', '45322', 0.00), (258, 'THEODORA', 'MEJIA', '448 SKI ROAD', 'Squirrel Hill', 'PA', '15217', 1935.91), (259, 'SHELBY', 'STARK', '370 ALDER DRIVE', 'Sissonville', 'WV', '25320', 610.39), (260, 'MARLIN', 'GATES', '511 GEMINI DRIVE', 'Loveland', 'OH', '45140', 0.00), (261, 'AUBREY', 'YARBROUGH', '1637 KELSAN CIRCLE', 'Florence Villa', 'FL', '33880', 839.15), (262, 'PHYLISS', 'KAISER', '1468 TERRACE HILLS DRIVE', 'Parkville', 'MD', '21234', 1088.22), (263, 'KEELY', 'MURPHY', '1765 GLENKERRY CIRCLE', 'Bovina', 'NY', '13740', 1090.32), (264, 'LANA', 'PAYTON', '596 JOYCE ROAD', 'Buckland', 'MA', '01338', 1000.64), (265, 'CLINT', 'ROBBINS', '1610 BERN STREET', 'Mount Ulla', 'NC', '28125', 3340.93), (266, 'MELODY', 'ARELLANO', '837 C STREET', 'Duncansville', 'PA', '16635', 747.90), (267, 'FELECIA', 'KEYES', '1269 ELLEN CIRCLE', 'Rootstown', 'OH', '44272', 328.78), (268, 'CARY', 'GALLOWAY', '1222 CAMPBELL TERRACE DRIVE', 'Niagara', 'NY', '14300', 0.00), (269, 'JOSEPHINA', 'MAURER', '1769 LOWER DEVILS END DRIVE', 'Arnoldtown', 'MD', '21718', 353.93), (270, 'TOSHA', 'CLEVELAND', '244 SEWARD SB OFF DIMOND RAMP', 'Hartford', 'CT', '06126', 648.64), (271, 'SUNG', 'MCBRIDE', '608 CONSTITUTION CIRCLE', 'Sunnymede Woods', 'IN', '46803', 0.00), (272, 'MORRIS', 'NICHOLS', '1432 WEST 94TH COURT', 'Hartsfield', 'PA', '16930', 0.00), (273, 'TAMARA', 'MAXWELL', '420 ASKELAND DRIVE', 'Palmers Crossing', 'MS', '39401', 826.90), (274, 'ANTOINETTE', 'CONNER', '1567 RIO GRANDE ROAD', 'Bellefontaine', 'OH', '43311', 1524.23), (275, 'SANDY', 'MATOS', '1007 FERNDALE STREET', 'Little York', 'NJ', '08834', 1565.58), (276, 'BERNARD', 'BARAJAS', '758 CAMINO PLACE', 'South Acworth', 'NH', '03607', 1798.43), (277, 'ELLA', 'BOUCHARD', '1068 JOANNE CIRCLE', 'Chamblee', 'GA', '30341', 341.17), (278, 'HAYLEY', 'PAGE', '1909 BIRCH LANE', 'Suffolk', 'VA', '23439', 409.84), (279, 'ALLEN', 'DARLING', '132