Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

104 taos ct dauphin island al 36528

20/10/2021 Client: muhammad11 Deadline: 2 Day

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

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Helping Hand
Coursework Help Online
Coursework Helper
Smart Homework Helper
Assignment Helper
Top Class Results
Writer Writer Name Offer Chat
Helping Hand

ONLINE

Helping Hand

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$22 Chat With Writer
Coursework Help Online

ONLINE

Coursework Help Online

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$45 Chat With Writer
Coursework Helper

ONLINE

Coursework Helper

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$34 Chat With Writer
Smart Homework Helper

ONLINE

Smart Homework Helper

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$29 Chat With Writer
Assignment Helper

ONLINE

Assignment Helper

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$40 Chat With Writer
Top Class Results

ONLINE

Top Class Results

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$42 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Assignment 2 - Penn foster college early childhood education - Curing the incurable cookbook by gary null - Biggest challenges facing organizations in the next 20 years powerpoint - Research paper. - Use APPARTS to analyze the primary source document. - UTERINE FIBROIDS - Capstone Change Project Evaluation Plan (Fall prevention strategies in hospitals) - Matthew clark price list - Thesis review - Disciplinary actions for plagiarism at penn foster - 510 SPD Benchmark Due Process - Guangzhou dream factory trailer - How to make an observer minecraft - Gavin parsons and associates - How to write a legal memorandum - Lumière supporting a virtual workspace on the cloud - Aluminum sulfite molar mass - Business Valuation - Need to be answered in depth with no plagiarism. - Economists normally assume people's preferences should be - 2log10 5 log10 4 - Business - Fundamental methods of mathematical economics 3rd edition solutions - Read Carefully - Two major forms of workforce diversity - Rapid sand filter pdf - The tires of a car make revolutions - Wk 3, IOP 480: DR 1 - Correct entry to replenish a petty cash fund - Peyton approved balance sheet as of september 30 2018 - Basic networking tutorial for beginners - Strategic Planning Discussion - 5.6 kg in pounds - Dunkin donuts human resources for employees - Bsbitu306 design and produce business documents assessment 1 answers - From the epic of gilgamesh answer key - Night by elie wiesel chapter 1 quotes - Home burial analysis - Leadership Literature - Assessment due in 48 hours - 150 words - Liberal arts lenses chart - Statistical Analysis I - MULTIPLE CHOICE QUESTIONS - Wincc runtime advanced manual - Lizze broadway and tanner buchanan breakup - Jack rothman approaches to community intervention - Prism arcadian concrete interlocking sections patio stone - Export business plan research paper - Equal employment opportunity in hrm ppt - Interest rate parity theory ppt - Non-for -profit discussion 1 responses - Bubble gum song dr jean - What does a cognitive neuroscientist study inquizitive - Certificate 4 in security operations - Practice cold read task excerpt from the preface answers - The nazis were furious when italy surrendered and they ______ - OE W 1 D - Long term parking by arman - Iu east campus map - Time value problems - What did the ape think of the grape's house answers - Dq response - Risk Register - Did marilyn monroe have bpd - Surface area of oblique pyramid - Bristol eye hospital a&e - Ingrid jonker poem by sally bryer - Australian beer pong rules - Starbucks functional strategy - Nurse educator job interview questions - Case Study - A truck acquired at a cost of - Paper - What is the square root of 512 - Which of the following statements is not true of the merchandise classification scheme? - Vce accounting study design - Positive and negative number cards - Partridge v crittenden 1968 2 all er 421 hc qbd - Communication Assessment Project - Uc berkeley academic guide - Where anonymity breeds contempt questions for study and discussion - Market structure comparison table homework assignment - Autolite 145 cross reference - 4 noble truths worksheet - What bones make up the pectoral girdle - Importance of ihi certificate wgu - What year did romulus die - Simon st josephs ferntree gully - Adscititious in a sentence - Spell checking software catches nonword errors - Cdhp basic full hap epa - Market penetration assignment due in 18 hours - Www citewrite qut edu au - What is unbalanced force - Reflect Paper due tomorrow at midnight - Issue retiring employees lost knowledge - Gmdss radio log book pdf - The story chapter 21