1. A financial total to the sales and gross profit.

2. A hash total to the quantity sold and discount.

3. A record count to the no. of orders.

4. A check to validate that the Customer ID is ONLY numerical and ranges from 10000 to 22999.

5. A check to validate that the quantity sold is between 1 and 10 units.

6. A check to validate that Sales is the product of quantity multiplied by the price.

7. A check to validate that the gross profit equals cannot be less than 9.9% of sales. Mention the type of check.

8. A check to validate that the sales discount: 1) cannot be negative, 2) ranges from 0% to 45%.

o 1 2 3 1 5 A Row ID 1 2 3 4 5 6 7 8 9 6 7 8 8 9 10 11 12 13 10 11 12 13 14 15 B C D E F G H | K L Order ID Order Date Ship Date Customer ID Customer Name Postal Code Product ID Category Sub-Category Product Name Price CA 2016 152156 11/8/2016 11/11/2016 12520 Clairc Gutc 42420 FUR BO 10001798 Furniture Bookcascs Bush Somerset Collection Bookcasc 130.98 CA-2016-152156 11/8/2016 11/11/2016 12520 Claire Gute 12120 FUR-CH-10000454 Furniture Chairs luxe Fabric Upholstered Stacking Chairs, Round 213.98 CA-2016-138688 6/12/2016 6/16/2016 DV-13045 Darrin Van Huff 90036 OFF-LA-10000240 Office Supplies Labels dhesive Address Labels for Typewriters by Univ 7.31 US-2015-108966 10/11/2015 10/18/2015 20335 Sean O'Donnell 33311 FUR-TA-10000577 Furniture Tables Bretford CR4500 Series Slim Rectangular Table 191.516 US-2015-108966 10/11/2015 10/18/2015 20335 Sean O'Donnell 33311 OFF-ST-10000760 Office Supplies Storage Eldon Fold 'N Roll Cart System 11.184 CA-2014-115812 6/9/2014 6/14/2014 11710 Brosina Hottman 90032 FUR-FU-10001487 Furniture Furnishings essions Wood and Plastic Desk Accessories, Chi 6.98 CA-2014-115812 6/9/2014 6/14/2014 11710 Brosina Hottman 90032 OFF-AR-10002833 Ottice Supplies Art Newell 322 1.82 CA-2014-115812 6/9/2014 6/14/2014 11/10 Brosina Hoffman 90032 TEC-PH-10002275 Technology Phones Mitel 5320 IP Phone VoIP phone 151.192 CA-2014-115812 6/9/2014 6/14/2014 11710 Brosina Hoffman 90032 OFF-Bl-10003910 Office Supplies Binders Angle-View Binders with Locking Rings by Sam 6.168 CA-2014-115812 6/9/2014 6/14/2014 11710 Brosina Hoffman 90032 OFF-AP-10002892 Office Supplies Appliances Belkin F5C206VTEL 6 Outlet Surge 22.98 CA-2014-115812 6/9/2014 6/14/2014 11710 Brosina Hoffman 90032 FUR-TA-10001539 Furniture Tables Chromcraft Rectangular Conference Tables 189.576 CA-2014-115812 6/9/2014 6/14/2014 - 11710 Brosina Hoffman 90032 TEC-PH-10002033 Technology Phones Kontel 250 Conference phone - Charcoal black 227.856 CA-2017-114412 4/15/2017 4/20/2017 AA-10480 Andrew Allen 28027 OFF-PA-10002365 Office Supplies Paper Xerox 1967 5.184 CA-2016-161389 12/5/2016 12/10/2016 15070 Irene Maddox 98103 OFF-BI-10003656 Office Supplies Binders Fellowes PB200 Plastic Comb Binding Machine 135.992 US-2015-118983 11/22/2015 11/26/2015 14815 Ilarold Pawlan 76106 Orr-AP-10002311 Office Supplies Appliances ment Filter for IICPA Air Cleaner, Very Large Ro -13.762 US 2015 118983 11/22/2015 11/26/2015 14815 Harold Pawlan 76106 OFF BI 10000756 Office Supplics Binders itorex DuraTech Recycled Plastic Frosted Binder 0.848 CA-2011-105893 11/11/2011 11/18/2011 19075 Pete Kriz 53711 OFF-ST-10001186 Office Supplies Storage Stor Shelving, Vertical 5-Shelf: 72"H x 36"W x 1: 110.98 CA-2011-167161 5/13/2011 5/15/2011 10270 Alejandro Grove 81081 OFF-ST-10000107 Office Supplies Storage Fellowes Super Stor/Drawer 27.75 CA-2014-143336 8/27/2014 9/1/2014 21925 Zuschuss Donatelli 94109 OFF-AR-10003056 Office Supplies Art Newell 341 4.28 CA-2014-143336 8/27/2014 9/1/2014 21925 Zuschuss Donatelli 94109 TEC-PH-10001949 Technology Phones Cisco SPA 501G IP Phone 71.16 CA-2014-143336 8/27/2014 9/1/2014 21925 Zuschuss Donatelli 94109 OFF-BI-10002215 Office Supplies Binders Wilson lones Hanging View Binder, White, 1" 5.68 CA-2016-137330 12/9/2016 12/13/2016 16585 Ken Black 68025 OFF-AR-10000246 Ottice Supplies Art Newell 318 0 CA-2016-137330 12/9/2016 12/13/2016 16585 Ken Black 68025 OFF-AP-10001492 Office Supplies Appliances Acco Six-Outlet Power Strip, 4' Cord Length 8.62 US-2017-156909 1/16/2017 1/18/2017 29999 Sandra Flanagan 19140 FUR-CH-10002/14 Furniture Chairs Global Deluxe Stacking Chair, Gray 35.686 CA-2015-106320 9/25/2015 9/30/2015 13870 Emily Burns 84057 FUR-TA-10000577 Furniture Tables Bretford CR4500 Series Slim Rectangular Table 348.21 CA-2016-121755 1/16/2016 1/20/2016 13940 Eric Hoffmann 90049 OFF-BI-10001634 Office Supplies Binders Wilson Jones Active Use Binders 5.824 M N Quantity Sales 2 261.96 3 731.91 2 14.62 -5 -957.58 2 22.368 7 48.86 4 7.28 6 907.152 3 18.504 5 114.9 9 1706.18 4 911.424 3 15.552 3 3 407.976 5 68.81 3 25.44 6 665.88 2 2 55.5 2 2 8.56 3 213.48 4 22.72 7 19.46 1 60.34 2 /1.3/2 3 1044.63 2 11.648 Discount Gross Profit 0 41.9136 0 219.582 0 6.8714 0.45 -383.031 0.2 2.5164 0 14.1694 0 1.9656 -0.2 90./152 0.2 5.7825 0 34.47 0.2 85.3092 0.2 68.3568 0.2 5.4432 0.2 132.5922 0.8 -123.858 0.8 3.816 0 13.3176 0 9.99 0 2.4824 0.2 16.011 0.2 7.384 0 5.0596 0 15.6884 0.3 -1.0196 0 240.2649 0.2 4.2224 14 15 16 17 16 19 17 18 19 19 20 21 22 23 20 21 22 24 25 26 27 28 23 24 25 26 o 1 2 3 1 5 A Row ID 1 2 3 4 5 6 7 8 9 6 7 8 8 9 10 11 12 13 10 11 12 13 14 15 B C D E F G H | K L Order ID Order Date Ship Date Customer ID Customer Name Postal Code Product ID Category Sub-Category Product Name Price CA 2016 152156 11/8/2016 11/11/2016 12520 Clairc Gutc 42420 FUR BO 10001798 Furniture Bookcascs Bush Somerset Collection Bookcasc 130.98 CA-2016-152156 11/8/2016 11/11/2016 12520 Claire Gute 12120 FUR-CH-10000454 Furniture Chairs luxe Fabric Upholstered Stacking Chairs, Round 213.98 CA-2016-138688 6/12/2016 6/16/2016 DV-13045 Darrin Van Huff 90036 OFF-LA-10000240 Office Supplies Labels dhesive Address Labels for Typewriters by Univ 7.31 US-2015-108966 10/11/2015 10/18/2015 20335 Sean O'Donnell 33311 FUR-TA-10000577 Furniture Tables Bretford CR4500 Series Slim Rectangular Table 191.516 US-2015-108966 10/11/2015 10/18/2015 20335 Sean O'Donnell 33311 OFF-ST-10000760 Office Supplies Storage Eldon Fold 'N Roll Cart System 11.184 CA-2014-115812 6/9/2014 6/14/2014 11710 Brosina Hottman 90032 FUR-FU-10001487 Furniture Furnishings essions Wood and Plastic Desk Accessories, Chi 6.98 CA-2014-115812 6/9/2014 6/14/2014 11710 Brosina Hottman 90032 OFF-AR-10002833 Ottice Supplies Art Newell 322 1.82 CA-2014-115812 6/9/2014 6/14/2014 11/10 Brosina Hoffman 90032 TEC-PH-10002275 Technology Phones Mitel 5320 IP Phone VoIP phone 151.192 CA-2014-115812 6/9/2014 6/14/2014 11710 Brosina Hoffman 90032 OFF-Bl-10003910 Office Supplies Binders Angle-View Binders with Locking Rings by Sam 6.168 CA-2014-115812 6/9/2014 6/14/2014 11710 Brosina Hoffman 90032 OFF-AP-10002892 Office Supplies Appliances Belkin F5C206VTEL 6 Outlet Surge 22.98 CA-2014-115812 6/9/2014 6/14/2014 11710 Brosina Hoffman 90032 FUR-TA-10001539 Furniture Tables Chromcraft Rectangular Conference Tables 189.576 CA-2014-115812 6/9/2014 6/14/2014 - 11710 Brosina Hoffman 90032 TEC-PH-10002033 Technology Phones Kontel 250 Conference phone - Charcoal black 227.856 CA-2017-114412 4/15/2017 4/20/2017 AA-10480 Andrew Allen 28027 OFF-PA-10002365 Office Supplies Paper Xerox 1967 5.184 CA-2016-161389 12/5/2016 12/10/2016 15070 Irene Maddox 98103 OFF-BI-10003656 Office Supplies Binders Fellowes PB200 Plastic Comb Binding Machine 135.992 US-2015-118983 11/22/2015 11/26/2015 14815 Ilarold Pawlan 76106 Orr-AP-10002311 Office Supplies Appliances ment Filter for IICPA Air Cleaner, Very Large Ro -13.762 US 2015 118983 11/22/2015 11/26/2015 14815 Harold Pawlan 76106 OFF BI 10000756 Office Supplics Binders itorex DuraTech Recycled Plastic Frosted Binder 0.848 CA-2011-105893 11/11/2011 11/18/2011 19075 Pete Kriz 53711 OFF-ST-10001186 Office Supplies Storage Stor Shelving, Vertical 5-Shelf: 72"H x 36"W x 1: 110.98 CA-2011-167161 5/13/2011 5/15/2011 10270 Alejandro Grove 81081 OFF-ST-10000107 Office Supplies Storage Fellowes Super Stor/Drawer 27.75 CA-2014-143336 8/27/2014 9/1/2014 21925 Zuschuss Donatelli 94109 OFF-AR-10003056 Office Supplies Art Newell 341 4.28 CA-2014-143336 8/27/2014 9/1/2014 21925 Zuschuss Donatelli 94109 TEC-PH-10001949 Technology Phones Cisco SPA 501G IP Phone 71.16 CA-2014-143336 8/27/2014 9/1/2014 21925 Zuschuss Donatelli 94109 OFF-BI-10002215 Office Supplies Binders Wilson lones Hanging View Binder, White, 1" 5.68 CA-2016-137330 12/9/2016 12/13/2016 16585 Ken Black 68025 OFF-AR-10000246 Ottice Supplies Art Newell 318 0 CA-2016-137330 12/9/2016 12/13/2016 16585 Ken Black 68025 OFF-AP-10001492 Office Supplies Appliances Acco Six-Outlet Power Strip, 4' Cord Length 8.62 US-2017-156909 1/16/2017 1/18/2017 29999 Sandra Flanagan 19140 FUR-CH-10002/14 Furniture Chairs Global Deluxe Stacking Chair, Gray 35.686 CA-2015-106320 9/25/2015 9/30/2015 13870 Emily Burns 84057 FUR-TA-10000577 Furniture Tables Bretford CR4500 Series Slim Rectangular Table 348.21 CA-2016-121755 1/16/2016 1/20/2016 13940 Eric Hoffmann 90049 OFF-BI-10001634 Office Supplies Binders Wilson Jones Active Use Binders 5.824 M N Quantity Sales 2 261.96 3 731.91 2 14.62 -5 -957.58 2 22.368 7 48.86 4 7.28 6 907.152 3 18.504 5 114.9 9 1706.18 4 911.424 3 15.552 3 3 407.976 5 68.81 3 25.44 6 665.88 2 2 55.5 2 2 8.56 3 213.48 4 22.72 7 19.46 1 60.34 2 /1.3/2 3 1044.63 2 11.648 Discount Gross Profit 0 41.9136 0 219.582 0 6.8714 0.45 -383.031 0.2 2.5164 0 14.1694 0 1.9656 -0.2 90./152 0.2 5.7825 0 34.47 0.2 85.3092 0.2 68.3568 0.2 5.4432 0.2 132.5922 0.8 -123.858 0.8 3.816 0 13.3176 0 9.99 0 2.4824 0.2 16.011 0.2 7.384 0 5.0596 0 15.6884 0.3 -1.0196 0 240.2649 0.2 4.2224 14 15 16 17 16 19 17 18 19 19 20 21 22 23 20 21 22 24 25 26 27 28 23 24 25 26