Question

1 Approved Answer

Posted on Aug 01, 2024

HELP ME CREATE AND SQL CODE TO DISPLAY THE FOLLOWING QUESTIONS THE THREE TABLES ARE PROVIDED BELOW 7. Which customers have individual sales exceeding $25,000?

HELP ME CREATE AND SQL CODE TO DISPLAY THE FOLLOWING QUESTIONS

THE THREE TABLES ARE PROVIDED BELOW

image text in transcribed

7. Which customers have individual sales exceeding $25,000? Please display the customer ID, customer name and sales amount. Show the SQL statement 3 Cash_receipts Sales_order- 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 Customer_masterfile Sales_data Cust_ID - Transaction[ - Trans Type - InvoiceDate - 1836 5-Mar-17 Sales 5-Mar-17 1168 5-Mar-17 Sales 5-Mar-17 1167 5-Mar-17 Sales 5-Mar-17 1841 8-Mar-17 Sales 8-Mar-17 1842 8-Mar-17 Sales 8-Mar-17 1168 13-Mar-17 Sales 13-Mar-17 1167 13-Mar-17 Sales 13-Mar-17 1814 13-Mar-17 Sales 13-Mar-17 1841 17-Mar-17 Sales 17-Mar-17 1842 17-Mar-17 Sales 17-Mar-17 1843 17-Mar-17 Sales 17-Mar-17 1861 23-Mar-17 Sales 23-Mar-17 1863 23-Mar-17 Sales 23-Mar-17 1864 23-Mar-17 Sales 23-Mar-17 1840 27-Mar-17 Sales 27-Mar-17 1841 27-Mar-17 Sales 27-Mar-17 1842 30-Mar-17 Sales 30-Mar-17 1167 2-Apr-17 Sales 2-Apr-17 1814 3-Apr-17 Sales 3-Apr-17 1838 3-Apr-17 Sales 3-Apr-17 1863 6-Apr-17 Sales 6-Apr-17 1864 6-Apr-17 Sales 6-Apr-17 1861 6-Apr-17 Sales 6-Apr-17 1862 6-Apr-17 Sales 6-Apr-17 1840 10-Apr-17 Sales 10-Apr-17 1841 10-Apr-17 Sales 10-Apr-17 1842 12-Apr-17 Sales 12-Apr-17 1861 17-Apr-17 Sales 17-Apr-17 1842 17-Apr-17 Sales 17-Apr-17 1843 17-Apr-17 Sales 17-Apr-17 1836 23-Apr-17 Sales 23-Apr-17 1841 23-Apr-17 Sales 23-Apr-17 1168 23-Apr-17 Sales 23-Apr-17 1837 23-Apr-17 Sales 23-Apr-17 1841 23-Apr-17 Sales 23-Apr-17 1814 23-Apr-17 Sales 23-Apr-17 1167 23-Apr-17 Sales 23-Apr-17 1861 24-Apr-17 Sales 24-Apr-17 1837 24-Apr-17 Sales 24-Apr-17 1842 27-Apr-17 Sales 27-Apr-17 ShipDate - 5-Mar-17 5-Mar-17 5-Mar-17 8-Mar-17 8-Mar-17 13-Mar-17 13-Mar-17 13-Mar-17 18-Mar-17 18-Mar-17 18-Mar-17 23-Mar-17 23-Mar-17 23-Mar-17 27-Mar-17 27-Mar-17 30-Mar-17 2-Apr-17 3-Apr-17 3-Apr-17 6-Apr-17 6-Apr-17 6-Apr-17 6-Apr-17 10-Apr-17 10-Apr-17 12-Apr-17 18-Apr-17 18-Apr-17 18-Apr-17 23-Apr-17 23-Apr-17 23-Apr-17 23-Apr-17 23-Apr-17 23-Apr-17 23-Apr-17 24-Apr-17 24-Apr-17 27-Apr-17 Sale_Amt - Click to Add- $16,158.00 $9,144.00 $15,738.00 $6,008.00 $7,242.00 $8,476.00 $15,738.00 $9,085.00 $4,240.00 $5,994.00 $9,020.00 $6,553.00 $5,009.00 $11,114.00 $17,678.00 $4,240.00 $7,242.00 $19,672.00 $6,975.00 $16,230.00 $7,331.00 $13,892.00 $8,075.00 $9,642.00 $22,097.00 $7,510.00 $9,052.00 $8,191.00 $9,052.00 $11,274.00 $19,572.00 $1,300.00 $10,850.00 $7,600.00 $702.00 $4,381.00 $19,312.00 $8,075.00 $14,093.00 $9,052.00 Cash_receipts Customer_masterfile Sales_data Cust_ID - Cust_Name - Bill_Add - Shipp_Add - Cust_Contac - Credit_Limit - Click to Add- 1167 Goodway 932 5th Ave. 712 Soho St. Erin Watt 60,000.00 1168 JumpStart 413 Elizabeth S 789 Gretzky Av Julia Smith 65,000.00 1814 ValueChoice 81 Frog Ave. 65 Racoon St. Samantha Reyr 30,000.00 1836 Runner's Mark 3614 Rodeo Dr. 5812 Winters S Max Rios 60,000.00 1837 Cool Threads 666 Georgia Dr. 800 Angel St. Cassius Clay 25,000.00 1838 City Slicker Rur 2379 Ventura C 6689 Ace St. Dick Pepperfie 64,000.00 1839 Southern Runn 5678 42nd St. 8991 67th St. Dixie Walters 80,000.00 1840 Super Runners 33 Gordon Ave 48 Jefferson St Chad Ochocino 60,000.00 1841 Neighborhood 2 Boykin Dr. 137 Heisman St April Brady 50,000.00 1842 Western Lites 74 Spooner St. 315 Alamida Ai Chad Brady 250,000.00 1843 Southeast Regi 2110 Woodshe 7489 Stadium C Pete Macalliste 80,000.00 1861 Family Fit 6452 Wilson Dr 7510 Wood St. Connor Broden 35,000.00 1862 Corner Runner 7773 Tropic Ave 5216 Stoops St. Jackie Moon 75,000.00 1863 Runners Galley 21 Savage St. 38 Knife Ave. Summer Day 50,000.00 1864 Cross Country I 1111 Maryland 8788 Independ Will Ratatouille 22,000.00 1865 Urban Athletic 587 Baylor Suck 3127 Lee Dr. Theodore Jeffe 11,000.00 1866 Uncle Bartham 830 Bears Ave 830 Bears Ave Jay Cutler 15,000.00 1867 Mary America 308 Brushy Cre 310 Brushy Cre Marvin Gay 10,000.00 1868 Wilting Summe 682 Bryer klear 682 Bryer klear Martha Stewer 27,000.00 11001 Cash_receipts Customer_masterfile Sales_data PAY_ID - Sales_orderl - Cust_ID - Cust_Name - Transaction - Trans_Type - 1001 1836 Runner's Markt 3/25/2017 CashReceipt 11002 1002 1168 JumpStart 4/8/2017 CashReceipt 11003 1003 1167 Goodway 4/17/2017 CashReceipt 11004 1004 1841 Neighborhood 4/9/2017 CashReceipt 11005 1005 1842 Western Lites 4/3/2017 CashReceipt 11006 1006 1168 JumpStart 4/22/2017 CashReceipt 11007 1007 1167 Goodway 4/30/2017 CashReceipt 11008 1008 1814 ValueChoice 5/4/2017 CashReceipt 11009 1009 1841 Neighborhood 5/19/2017 CashReceipt 11010 1010 1842 Western Lites 5/28/2017 CashReceipt 11011 1011 1843 Southeast Regi 5/12/2017 Cash Receipt 11012 1012 1861 Family Fit 5/2/2017 CashReceipt 11013 1013 1863 Runners Galley 5/25/2017 Cash Receipt 11014 1014 1864 Cross Country! 5/7/2017 Cash Receipt 11015 1015 1840 Super Runners 5/14/2017 CashReceipt 11016 1016 1841 Neighborhood 5/18/2017 CashReceipt 11017 1017 1842 Western Lites 4/22/2017 Cash Receipt 11018 1018 1167 Goodway 4/30/2017 CashReceipt 11019 1019 1814 ValueChoice 5/7/2017 CashReceipt 11020 1020 1838 City Slicker Rur 5/19/2017 CashReceipt 11021 1021 1863 Runners Galley 5/29/2017 CashReceipt 11022 1022 1864 Cross Country 5/11/2017 CashReceipt 11023 1023 1861 Family Fit 5/14/2017 CashReceipt 11024 1024 1862 Corner Runner 5/25/2017 CashReceipt 11025 1025 1840 Super Runners 6/8/2017 Cash Receipt 11026 1026 1841 Neighborhood 5/10/2017 CashReceipt 11027 1027 1842 Western Lites 5/17/2017 CashReceipt 11028 1028 1861 Family Fit 6/10/2017 CashReceipt 11030 1030 1843 Southeast Regi 5/17/2017 Cash Receipt 11031 1031 1836 Runner's Marke 5/23/2017 CashReceipt 11032 1032 1841 Neighborhood 5/29/2017 CashReceipt 11033 1033 1168 JumpStart 6/4/2017 Cash Receipt 11034 1034 1837 Cool Threads 7/18/2017 Cash Receipt 11035 1035 1841 Neighborhood 7/6/2017 CashReceipt 11036 1036 1814 ValueChoice 6/20/2017 CashReceipt 11037 1037 1167 Goodway 6/10/2017 Cash Receipt 11038 1038 1861 Family Fit 7/3/2017 CashReceipt 11039 1039 1837 Cool Threads 6/25/2017 CashReceipt 11040 1040 1842 Western Lites 6/23/2017 CashReceipt 11041 1041 1843 Southeast Regi 6/26/2017 CashReceipt Paid_Amt - Click to Add- $16,158.00 $9,144.00 $15,738.00 $6,008.00 $7,242.00 $8,476.00 $15,738.00 $9,085.00 $4,240.00 $5,994.00 $9,020.00 $6,553.00 $5,009.00 $11,114.00 $17,678.00 $4,240.00 $7,242.00 $19,672.00 $6,975.00 $16,230.00 $7,331.00 $13,892.00 $8,075.00 $9,642.00 $22,097.00 $7,510.00 $9,052.00 $8,191.00 $10,000.00 $19,572.00 $1,300.00 $10,850.00 $7,600.00 $702.00 $4,381.00 $19,312.00 $8,075.00 $14,093.00 $9,052.00 $11,120.00 7. Which customers have individual sales exceeding $25,000? Please display the customer ID, customer name and sales amount. Show the SQL statement 3 Cash_receipts Sales_order- 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 Customer_masterfile Sales_data Cust_ID - Transaction[ - Trans Type - InvoiceDate - 1836 5-Mar-17 Sales 5-Mar-17 1168 5-Mar-17 Sales 5-Mar-17 1167 5-Mar-17 Sales 5-Mar-17 1841 8-Mar-17 Sales 8-Mar-17 1842 8-Mar-17 Sales 8-Mar-17 1168 13-Mar-17 Sales 13-Mar-17 1167 13-Mar-17 Sales 13-Mar-17 1814 13-Mar-17 Sales 13-Mar-17 1841 17-Mar-17 Sales 17-Mar-17 1842 17-Mar-17 Sales 17-Mar-17 1843 17-Mar-17 Sales 17-Mar-17 1861 23-Mar-17 Sales 23-Mar-17 1863 23-Mar-17 Sales 23-Mar-17 1864 23-Mar-17 Sales 23-Mar-17 1840 27-Mar-17 Sales 27-Mar-17 1841 27-Mar-17 Sales 27-Mar-17 1842 30-Mar-17 Sales 30-Mar-17 1167 2-Apr-17 Sales 2-Apr-17 1814 3-Apr-17 Sales 3-Apr-17 1838 3-Apr-17 Sales 3-Apr-17 1863 6-Apr-17 Sales 6-Apr-17 1864 6-Apr-17 Sales 6-Apr-17 1861 6-Apr-17 Sales 6-Apr-17 1862 6-Apr-17 Sales 6-Apr-17 1840 10-Apr-17 Sales 10-Apr-17 1841 10-Apr-17 Sales 10-Apr-17 1842 12-Apr-17 Sales 12-Apr-17 1861 17-Apr-17 Sales 17-Apr-17 1842 17-Apr-17 Sales 17-Apr-17 1843 17-Apr-17 Sales 17-Apr-17 1836 23-Apr-17 Sales 23-Apr-17 1841 23-Apr-17 Sales 23-Apr-17 1168 23-Apr-17 Sales 23-Apr-17 1837 23-Apr-17 Sales 23-Apr-17 1841 23-Apr-17 Sales 23-Apr-17 1814 23-Apr-17 Sales 23-Apr-17 1167 23-Apr-17 Sales 23-Apr-17 1861 24-Apr-17 Sales 24-Apr-17 1837 24-Apr-17 Sales 24-Apr-17 1842 27-Apr-17 Sales 27-Apr-17 ShipDate - 5-Mar-17 5-Mar-17 5-Mar-17 8-Mar-17 8-Mar-17 13-Mar-17 13-Mar-17 13-Mar-17 18-Mar-17 18-Mar-17 18-Mar-17 23-Mar-17 23-Mar-17 23-Mar-17 27-Mar-17 27-Mar-17 30-Mar-17 2-Apr-17 3-Apr-17 3-Apr-17 6-Apr-17 6-Apr-17 6-Apr-17 6-Apr-17 10-Apr-17 10-Apr-17 12-Apr-17 18-Apr-17 18-Apr-17 18-Apr-17 23-Apr-17 23-Apr-17 23-Apr-17 23-Apr-17 23-Apr-17 23-Apr-17 23-Apr-17 24-Apr-17 24-Apr-17 27-Apr-17 Sale_Amt - Click to Add- $16,158.00 $9,144.00 $15,738.00 $6,008.00 $7,242.00 $8,476.00 $15,738.00 $9,085.00 $4,240.00 $5,994.00 $9,020.00 $6,553.00 $5,009.00 $11,114.00 $17,678.00 $4,240.00 $7,242.00 $19,672.00 $6,975.00 $16,230.00 $7,331.00 $13,892.00 $8,075.00 $9,642.00 $22,097.00 $7,510.00 $9,052.00 $8,191.00 $9,052.00 $11,274.00 $19,572.00 $1,300.00 $10,850.00 $7,600.00 $702.00 $4,381.00 $19,312.00 $8,075.00 $14,093.00 $9,052.00 Cash_receipts Customer_masterfile Sales_data Cust_ID - Cust_Name - Bill_Add - Shipp_Add - Cust_Contac - Credit_Limit - Click to Add- 1167 Goodway 932 5th Ave. 712 Soho St. Erin Watt 60,000.00 1168 JumpStart 413 Elizabeth S 789 Gretzky Av Julia Smith 65,000.00 1814 ValueChoice 81 Frog Ave. 65 Racoon St. Samantha Reyr 30,000.00 1836 Runner's Mark 3614 Rodeo Dr. 5812 Winters S Max Rios 60,000.00 1837 Cool Threads 666 Georgia Dr. 800 Angel St. Cassius Clay 25,000.00 1838 City Slicker Rur 2379 Ventura C 6689 Ace St. Dick Pepperfie 64,000.00 1839 Southern Runn 5678 42nd St. 8991 67th St. Dixie Walters 80,000.00 1840 Super Runners 33 Gordon Ave 48 Jefferson St Chad Ochocino 60,000.00 1841 Neighborhood 2 Boykin Dr. 137 Heisman St April Brady 50,000.00 1842 Western Lites 74 Spooner St. 315 Alamida Ai Chad Brady 250,000.00 1843 Southeast Regi 2110 Woodshe 7489 Stadium C Pete Macalliste 80,000.00 1861 Family Fit 6452 Wilson Dr 7510 Wood St. Connor Broden 35,000.00 1862 Corner Runner 7773 Tropic Ave 5216 Stoops St. Jackie Moon 75,000.00 1863 Runners Galley 21 Savage St. 38 Knife Ave. Summer Day 50,000.00 1864 Cross Country I 1111 Maryland 8788 Independ Will Ratatouille 22,000.00 1865 Urban Athletic 587 Baylor Suck 3127 Lee Dr. Theodore Jeffe 11,000.00 1866 Uncle Bartham 830 Bears Ave 830 Bears Ave Jay Cutler 15,000.00 1867 Mary America 308 Brushy Cre 310 Brushy Cre Marvin Gay 10,000.00 1868 Wilting Summe 682 Bryer klear 682 Bryer klear Martha Stewer 27,000.00 11001 Cash_receipts Customer_masterfile Sales_data PAY_ID - Sales_orderl - Cust_ID - Cust_Name - Transaction - Trans_Type - 1001 1836 Runner's Markt 3/25/2017 CashReceipt 11002 1002 1168 JumpStart 4/8/2017 CashReceipt 11003 1003 1167 Goodway 4/17/2017 CashReceipt 11004 1004 1841 Neighborhood 4/9/2017 CashReceipt 11005 1005 1842 Western Lites 4/3/2017 CashReceipt 11006 1006 1168 JumpStart 4/22/2017 CashReceipt 11007 1007 1167 Goodway 4/30/2017 CashReceipt 11008 1008 1814 ValueChoice 5/4/2017 CashReceipt 11009 1009 1841 Neighborhood 5/19/2017 CashReceipt 11010 1010 1842 Western Lites 5/28/2017 CashReceipt 11011 1011 1843 Southeast Regi 5/12/2017 Cash Receipt 11012 1012 1861 Family Fit 5/2/2017 CashReceipt 11013 1013 1863 Runners Galley 5/25/2017 Cash Receipt 11014 1014 1864 Cross Country! 5/7/2017 Cash Receipt 11015 1015 1840 Super Runners 5/14/2017 CashReceipt 11016 1016 1841 Neighborhood 5/18/2017 CashReceipt 11017 1017 1842 Western Lites 4/22/2017 Cash Receipt 11018 1018 1167 Goodway 4/30/2017 CashReceipt 11019 1019 1814 ValueChoice 5/7/2017 CashReceipt 11020 1020 1838 City Slicker Rur 5/19/2017 CashReceipt 11021 1021 1863 Runners Galley 5/29/2017 CashReceipt 11022 1022 1864 Cross Country 5/11/2017 CashReceipt 11023 1023 1861 Family Fit 5/14/2017 CashReceipt 11024 1024 1862 Corner Runner 5/25/2017 CashReceipt 11025 1025 1840 Super Runners 6/8/2017 Cash Receipt 11026 1026 1841 Neighborhood 5/10/2017 CashReceipt 11027 1027 1842 Western Lites 5/17/2017 CashReceipt 11028 1028 1861 Family Fit 6/10/2017 CashReceipt 11030 1030 1843 Southeast Regi 5/17/2017 Cash Receipt 11031 1031 1836 Runner's Marke 5/23/2017 CashReceipt 11032 1032 1841 Neighborhood 5/29/2017 CashReceipt 11033 1033 1168 JumpStart 6/4/2017 Cash Receipt 11034 1034 1837 Cool Threads 7/18/2017 Cash Receipt 11035 1035 1841 Neighborhood 7/6/2017 CashReceipt 11036 1036 1814 ValueChoice 6/20/2017 CashReceipt 11037 1037 1167 Goodway 6/10/2017 Cash Receipt 11038 1038 1861 Family Fit 7/3/2017 CashReceipt 11039 1039 1837 Cool Threads 6/25/2017 CashReceipt 11040 1040 1842 Western Lites 6/23/2017 CashReceipt 11041 1041 1843 Southeast Regi 6/26/2017 CashReceipt Paid_Amt - Click to Add- $16,158.00 $9,144.00 $15,738.00 $6,008.00 $7,242.00 $8,476.00 $15,738.00 $9,085.00 $4,240.00 $5,994.00 $9,020.00 $6,553.00 $5,009.00 $11,114.00 $17,678.00 $4,240.00 $7,242.00 $19,672.00 $6,975.00 $16,230.00 $7,331.00 $13,892.00 $8,075.00 $9,642.00 $22,097.00 $7,510.00 $9,052.00 $8,191.00 $10,000.00 $19,572.00 $1,300.00 $10,850.00 $7,600.00 $702.00 $4,381.00 $19,312.00 $8,075.00 $14,093.00 $9,052.00 $11,120.00