- Pitt Fitness is selling a line of exercise clothing at their three locations. At the beginning of this venture, they decide to sell only three types of t-shirts with the Pitt Fitness logo: two womens sizes and one mens size. How would you use SQL to create a new table in the Pitt Fitness database to capture the line of t-shirts and their retail price? This new table would be used for advertising purposed only, so no quantity-on-hand fields are necessary.
- Write an SQL code query that would ask the database to count the number of different types of t-shirts available and total their price. Your output should show only the field names: NumberofTshirts and TotalPriceOfTshirts.
-
Table Tools Pitt Fitness (1): Database-C:\Users\Whitc\Downloads\Pitt Fitness (1).accdb (Access 2007... Carlton White CW File Home Create External Data Database Tools Help Totals Fields Table Tell me what you want to do - New abac Replace ABC Save Go To Spelling Refresh Find All X Delete - More As Select Calibri 11 View BIU A Records Find Text Formatting >> LengthofTime MaxSize Time Click to Add 60 + 60 60 30 + 60 + 60 + 60 60 + 60 & Cut A1 Ascending Y Selection Copy All Descending Advanced Paste Filter Format Painter 4 Remove Sort y Toggle Filter Views Clipboard Sort & Filter Classes x ClassID - ClassName Room Location 1 Combination 159B Shadyside 2 Yogalates 342 Downtown 3 Barbell Power Main Oakland 4 Intense Cycle 163 Shadyside 5 Zumba 159B Shadyside 6 Low Impact Ae Main Oakland 7 Yoga 342 Downtown 8 Yoga Balance Main Oakland 9 Barre Main Oakland 10 Barre Limited 342 Downtown 11 Maturity Endur Main Oakland 12 Maturity Classi 159B Shadyside 13 Agility for Seni Main Oakland 14 HIIT 315 Downtown 15 Bootcamp 159B Shadyside 16 Cycle 320 Downtown 17 Cycle and Strer 163 Shadyside 18 Aquasize Pool Oakland 19 Aqua Strength 125P Shadyside 20 Aqua Calm Pool Oakland 21 Combination 159B Shadyside 22 Yogalates 342 Downtown 23 Barbell Power Main Oakland 24 Intense Cycle 163 Shadyside Record: 1 1 of 40 No Filter Search Datasheet View 30 + 60 + 60 Navigation Pane - TypeofClass 40 Combo 25 Core 25 Strength 25 Cardio 25 Cardio 25 Cardio 25 Core 25 Core 25 Core 25 Core 25 Strength 25 Strength 25 Core 25 Cardio 25 Cardio 25 Cardio 25 Cardio 25 Cardio 25 Cardio 25 Strength 40 Combo 25 Core 25 Strength 25 Cardio Day Saturday Monday Tuesday Saturday Saturday Tuesday Tuesday Thursday Thursday Wednesday Friday Wednesday Friday Thursday Saturday Friday Sunday Tuesday Wednesday Tuesday Sunday Tuesday Wednesday Sunday Description 9:00 Cardio, strength, flexibility 6:00 Yoga and pilates fundamentals 8:00 Barbell program 10:00 Sprint 10:00 Zumba dance 11:00 Low impact aerobics 7:00 Traditional yoga 8:00 Balance yoga 9:00 Pilates yoga and aerobics 17:30 Barre brief 10:30 Cardio, strength, flexibility for older adults 7:00 Strength and movement for older Adults 9:30 Agility for older adults 18:00 High intensity interval drills 11:00 Weight training and cardio 6:30 Sprints and climbs 12:30 Cycle and strength 14:00 Low impact cardio water exercise 6:00 Strength and cardio in the water 13:00 Low impact water exercise 9:00 Cardio, strength, flexibility 6:00 Yoga and pilates fundamentals 8:00 Barbell program 10:00 Sprint + 60 + 30 30 + 60 60 + 60 60 + 45 + 60 + 60 60 + 30 Num Lock 11:29 PM 3/3/2021 Type here to search A 19 Table Tools Pitt Fitness (1): Database- C:\Users\Whitc\Downloads\Pitt Fitness (1).accdb (Access 2007... Carlton White CW Totals Calibri 11 Fields Table Tell me what you want to do - New abac Replace ABC Save Spelling Go To Refresh Find All-X Delete - More As Select Records Find View BIU A == Text Formatting >> Lengthoftime MaxSize Time - Click to Add 30 60 60 + 60 + 60 File Home Create External Data Database Tools Help & Cut Ascending Selection E Copy All Descending Advanced Paste Filter Format Painter 4 Remove Sort y Toggle Filter Views Clipboard Sort & Filter BE Classes X ClassID - ClassName Room Location - 24 Intense Cycle 163 Shadyside 25 Zumba 159B Shadyside + 26 Low Impact Ae Main Oakland 27 Yoga 342 Downtown 28 Yoga Balance Main Oakland 29 Barre Main Oakland 30 Barre Limited 342 Downtown 31 Maturity Endur Main Oakland 32 Maturity Classi 159B Shadyside 33 Agility for Seni Main Oakland 34 HIIT 315 Downtown 35 Bootcamp 159B Shadyside 36 Cycle 320 Downtown 37 Cycle and Strer 163 Shadyside 38 Aquasize Pool Oakland 39 Aqua Strength 125P Shadyside 40 Aqua Calm Pool Oakland * (New) 60 + 30 60 - TypeofClass - 25 Cardio 25 Cardio 25 Cardio 25 Core 25 Core 25 Core 25 Core 25 Strength 25 Strength 25 Core 25 Cardio 25 Cardio 25 Cardio 25 Cardio 25 Cardio 25 Cardio 25 Strength Day Sunday Sunday Wednesday Wednesday Friday Friday Thursday Saturday Thursday Saturday Friday Sunday Saturday Monday Wednesday Thursday Wednesday Description 10:00 Sprint 10:00 Zumba dance 11:00 Low impact aerobics 6:00 Traditional yoga 8:00 Balance yoga 9:00 Pilates yoga and aerobics 17:30 Barre brief 10:30 Cardio, strength, flexibility for older adults 7:00 Strength and movement for older adults 9:30 Agility for older adults 18:00 High intensity interval drills 11:00 Weight training and cardio 6:30 Sprints and climbs 12:30 Cycle and strength 14:00 Low impact cardio water exercise 6:00 Strength and cardio in the water 13:00 Low impact water exercise + 60 60 + 30 30 Navigation Pane + 60 60 60 60 45 Record: 1 of 40 No Filter Search Datasheet View Type here to search Num Lock 11:29 PM 3/3/2021 } > 6 719 Table Tools Pitt Fitness (1): Database-C:\Users\Whitc\Downloads\Pitt Fitness (1).accdb (Access 2007... Carlton White CW File Home Create External Data Database Tools Help Fields Table Tell me what you want to do Calibri 11 s New Totals ABC Save Refresh Spelling All X Delete - More abc Replace Go To Select- View Paste Find BIU . 2 lile II Views Records Find Text Formatting >> * Cut Ascending Selection Copy A Descending Advanced Filter Format Painter 4 Remove Sort y Toggle Filter Clipboard Sort & Filter Classinstructors X ClassID Instructorld. Click to Add 1 RS02 2 RS01 3 VP01 4 MS01 5 MK01 6 MK01 7 RS01 8 LLO1 9 LLO1 10 LLO1 11 MA01 11 MD01 12 MA01 12 MD01 13 MA01 13 MD01 14 RS01 15 RSO2 16 MS01 17 MS01 18 NT01 19 NT01 20 JV01 21 MD01 Navigation Pane Record: 1 of 46 No Filter Search Datasheet View Type here to search Num Lock 11:30 PM 3/3/2021 o > 19 Table Tools Pitt Fitness (1): Database-C:\Users\Whitc\Downloads\Pitt Fitness (1).accdb (Access 2007... Carlton White CW File Home Create External Data Database Tools Help Fields Table Tell me what you want to do Calibri 11 s New Totals ABC Save Refresh Spelling All X Delete - More abc Replace Go To Select- View Paste Find BIU A 2 lile II Views Records Find Text Formatting >> * Cut Ascending Selection Copy A Descending Advanced Filter Format Painter 4 Remove Sort y Toggle Filter Clipboard Sort & Filter Classinstructors X ClassID Instructorld. Click to Add 22 RS01 23 RS01 24 MS01 25 MK01 26 NT01 27 LLO1 28 RS01 29 VP01 30 VP01 31 MA01 31 MD01 32 MA01 32 MD01 33 MA01 33 MD01 34 RSO2 35 RSO2 36 MS01 37 MS01 38 JV01 39 JV01 40 NT01 Navigation Pane * 1 of 46 No Filter Search Record: Datasheet View Type here to search o 3 Num Lock 11:30 PM 3/3/2021 19 Table Tools Pitt Fitness (1): Database-C:\Users\Whitc\Downloads\Pitt Fitness (1).accdb (Access 2007... Carlton White CW Totals >> Phone Number File Home Create External Data Database Tools Help Fields Table Tell me what you want to do * Cut Ascending Selection - New ac Replace Calibri 11 ABC Le Copy All Descending Advanced Save Spelling Go To View Paste Filter Refresh Find Format Painter BIU A 4 Remove Sort y Toggle Filter As Select All X Delete - More Views Clipboard Sort & Filter & Records Find Text Formatting Customers X CustomerlD- LastName FirstName - StreetAddress City State ZipCode EmailAddress + 101 Aboud Nour 4898 Negley Ave Pittsburgh PA 15232 NourAboud@cengage.com + 102 Waldron Tony 766 Myrtle Way Pittsburgh PA 15232 TonyLWaldron@cengage.com + 103 # Arian Farah 998 Forward Ave Pittsburgh PA 15217 FarahArian@cengage.com + 104 Cane James 4310 Elmer St Pittsburgh PA 15232 James Cane@cengage.com + 105 Brescia Keith 1595 Holden St Pittsburgh PA 15232 Keith WBrescia@cengage.com + 106 Conner Don 3004 Alder St Pittsburgh PA 15232 DonsConner@cengage.com = + 107 Feldman Terrance 2158 Semple St Pittsburgh PA 15213 TerranceLFeldman@cengage.com + 108 Gregor Alice 392 Murray Ave Pittsburgh PA 15217 AliceRGregor@cengage.com + 109 Miller Roland 2542 York Way Pittsburgh PA 15213 RolandJMiller@cengage.com + 110 Sanchez Ramiro 4983 Mckee Pl Pittsburgh PA 15213 RamiroSanchez@cengage.com + 111 Barry Juan 4534 Urie Way Pittsburgh PA 15213 Juan RBarry@cengage.com + 112 Smith Sharon 1937 Bates St Pittsburgh PA 15213 Sharon MSmith@cengage.com + 113 Hatcher Charles 3218 Louisa St Pittsburgh PA 15213 CharlesMHatcher@cengage.com + 114 Spencer Glenn 2764 Oakland Ave Pittsburgh PA 15213 Glenn JSpencer@cengage.com # 115 Hearn James 1252 Pier St Pittsburgh PA 15213 JamesHearn@cengage.com + 116 Cornett Albert 3545 Ermine Way Pittsburgh PA 15213 AlbertACornett@cengage.com + 117 Devito Sylvia 3281 Fiber Way Pittsburgh PA 15213 SylviaKDevito@cengage.com + 118 Hill Jess 3161 Argyle Way Pittsburgh PA 15213 JessAHill@cengage.com + 119 Benavides Philip 1465 Butler St Pittsburgh PA 15201 PhilipCBenavides@cengage.com + 120 Patterson Margo 3291 Mahon St Pittsburgh PA 15219 MargoFPatterson@cengage.com + 121 Thorn Debbie 4434 Watt St Pittsburgh PA 15219 DebbielThorn@cengage.com + 122 Shaffer Gene 2041 Wylie Ave Pittsburgh PA 15219 GenekShaffer@cengage.com # 123 Brough Pablo 1812 Penn Ave Pittsburgh PA 15224 Pablo RBrough@cengage.com + 124 Agnew Betty 201 Barn Way Pittsburgh PA 15219 BettyBAgnew@cengage.com Record: 1 of 30 No Filter Search Datasheet View 412-255-5443 617-825-9347 878-243-9786 610-555-9951 724-943-0945 412-281-0129 559-673-4340 770-832-4718 412-266-5419 Navigation Pane 878-576-5221 210-444-4773 878-268-2455 561-550-8190 878-688-4980 231-640-8302 724-975-6688 256-486-5999 480-854-3611 Birth Date - Click to Adc 2/23/1998 8/23/1989 10/21/2000 2/1/1967 6/11/1948 5/18/1957 12/9/1987 2/16/1957 4/20/1984 4/1/1953 1/3/1958 10/16/1944 12/27/1976 5/7/1934 2/15/1996 9/29/1947 5/27/1949 1/4/1938 10/13/1994 9/19/1960 6/1/1968 6/10/2002 8/30/1975 11/23/1985 412-868-4146 412-290-1510 412-323-5436 281-817-7573 909-577-5726 878-263-7528 Num Lock E 11:30 PM 3/3/2021 719 Type here to search 0 ? Table Tools Pitt Fitness (1): Database-C:\Users\Whitc\Downloads\Pitt Fitness (1).accdb (Access 2007... Carlton White CW Totals ABC Paste >> File Home Create External Data Database Tools Help Fields Table Tell me what you want to do * Cut Ascending Selection - New abac Replace Calibri 11 Le Copy All Descending Advanced Save Spelling Go To View Filter Refresh Find == BIU A Format Painter 4 Remove Sort y Toggle Filter As Select All X Delete - More Views Clipboard Sort & Filter Records Find Text Formatting Customers X CustomerlDLastName - FirstName, StreetAddress City State ZipCode EmailAddress Phone Number + 124 Agnew Betty 201 Barn Way Pittsburgh PA 15219 BettyBAgnew@cengage.com 878-263-7528 + 125 McCauley Raymond 3254 Memory Lane Pittsburgh PA 15219 RaymondCMcCauley@cengage.com 878-345-0803 + 126 Sisto Robert 2836 Bedford Ave Pittsburgh PA 15219 RobertSisto@cengage.com 646-373-8125 + 127 Lara Tamara 4588 Monaca Pl Pittsburgh PA 15219 TamaraRLara@cengage.com 417-359-2241 + 128 Allen Michael 2367 Cliff St Pittsburgh PA 15219 Michael Allen@cengage.com 412-790-6275 + 129 Pegues Vicki 3700 Penn Ave Pittsburgh PA 15219 VickiJPegues@cengage.com 412-597-0247 + 130 Choi Min Jee 2661 Webster Ave Pittsburgh PA 15219 MinJeeChoi@cengage.com 412-868-5257 * BirthDate Click to Add 11/23/1985 3/10/1986 11/25/1966 8/31/1984 8/14/1966 12/14/1994 4/5/2001 Navigation Pane Record: 1 of 30 No Filter Search Datasheet View Type here to search > Num Lock 11:30 PM 3/3/2021 A 19 Table Tools Pitt Fitness (1): Database-C:\Users\Whitc\Downloads\Pitt Fitness (1).accdb (Access 2007... Carlton White CW Totals Spelling A Views >> File Home Create External Data Database Tools Help Fields Table Tell me what you want to do & Cut A1 Ascending Y Selection - New abac Replace Calibri 11 Copy Al Descending Advanced Save Go To View Paste Filter Refresh Find Format Painter 4 Remove Sort y Toggle Filter BIU As Select All X Delete - More Clipboard Sort & Filter Records Find Text Formatting BE Instructors X InstructoriD - InstructorLastName - InstructorFirstName - InstructorStreetAddress - InstructorCity - InstructorState - InstructorZipCode - + JV01 Varlano Juan 15A Penn Ave Pittsburgh PA 15219 + LLO1 Lane Luke 2661 Butler St Pittsburgh PA 15201 + MA01 Nguyen Michael 2367 Barn Way Pittsburgh PA 15219 + MD01 D'Angelo Maria 245D Wylie Ave Pittsburgh PA 15219 + MK01 Kobinski Megan 9087 Monanca PI Pittsburgh PA 15219 + MS01 Said Memo 45 Webster Ave Pittsburgh PA 15219 + NT01 Tahan Neda 4588 Penn Ave Pittsburgh PA 15219 + RS01 Stein Raymond 3254 Forward Ave Pittsburgh PA 15217 + RSO2 Sisto Robert 2836 Maryland Ave Pittsburgh PA 15232 # VP01 Pegues Vicki 3700 Murray Ave Pittsburgh PA 15217 InstructorEmailAddress InstructorPhoneNur JuanVarlano@cengage.com 412-998-6534 LukeCLane@cengage.com 561-868-5257 MichaelNguyen@cengage.com 951-790-6275 MariaDAngelo@cengage.com 724-887-2835 MeganKobinski@cengage.com 878-653-7364 MemoSaid@cengage.com 412-764-9834 Nedatahan@cengage.com 417-359-2241 RaymondStein@cengage.com 269-345-0803 RobertSisto@cengage.com 646-373-8125 VickiJPegues@cengage.com 678-597-0247 Navigation Pane 1 of 10 No Filter Search Record: Datasheet View Num Lock 11:31 PM 3/3/2021 Type here to search > 19 Table Tools Pitt Fitness (1): Database-C:\Users\Whitc\Downloads\Pitt Fitness (1).accdb (Access 2007... Carlton White CW File Home Create External Data Database Tools Help Calibri 11 * Cut Copy Format Painter Fields Table Tell me what you want to do - New Totals abc Replace Save Spelling Go To Refresh Find Select- All X Delete - More Records Find ABC View Paste A1 Ascending Y Selection Al Descending Advanced 4 Remove Sort y Toggle Filter Sort & Filter Filter BIU . 2 lile II Text Formatting >> OtherFees - CustomerID, Click to Add 102 $5.00 102 Views Clipboard BE Reservations X x Reservation - Classid 2100001 2100002 2100003 2100004 2100005 2100006 2100007 2100008 2100009 2100010 2100011 2100012 2100013 2100014 2100015 2100016 2100017 2100018 2100019 2100020 2100021 2100022 2100023 2100024 Record: 1 of 39 Datasheet View Navigation Pane ClassDate 39 1/7/2021 24 1/3/2021 10 1/6/2021 9 1/7/2021 7 1/5/2021 1 1/2/2021 2 1/4/2021 3 1/5/2021 5 1/2/2021 8 1/7/2021 4 1/2/2021 9 1/7/2021 10 1/6/2021 14 1/7/2021 15 1/2/2021 17 1/3/2021 18 1/5/2021 35 1/3/3021 36 1/2/2021 2 1/4/2021 9 1/7/2021 6 1/5/2021 4 1/2/2021 21 1/3/2021 No Filter Search ClassPrice - $9.00 $11.00 $9.00 $9.00 $9.00 $9.00 $9.00 $9.00 $9.00 $9.00 $9.00 $9.00 $9.00 $9.00 $9.00 $11.00 $10.00 $9.00 $11.00 $9.00 $9.00 $9.00 $11.00 $9.00 103 104 106 106 107 108 109 111 111 113 113 120 121 $5.00 122 123 124 $5.00 119 120 121 122 $5.00 123 124 Type here to search o Num Lock 11:31 PM 3/3/2021 3 19 Table Tools Pitt Fitness (1): Database-C:\Users\Whitc\Downloads\Pitt Fitness (1).accdb (Access 2007... Carlton White CW File Home Create External Data Database Tools Help Calibri Fields Table Tell me what you want to do s New Totals abc Replace Save Spelling Go To Refresh Find Select- All X Delete - More * Cut Copy Format Painter 11 ABC View Paste A1 Ascending Y Y Selection Al Descending Advanced 4 Remove Sort y Toggle Filter Sort & Filter Filter BIU A 2 lile II Records Find Text Formatting >> 24 26 15 Views Clipboard BE Reservations X x Reservation - Classid 2100025 2100026 2100027 2100028 2100029 2100030 2100031 2100032 2100033 2100034 25 29 27 31 ClassDate 1/3/2021 1/6/2021 1/2/2021 1/3/2021 1/8/2021 1/6/2021 1/2/2021 1/7/2021 1/2/2021 1/6/2021 1/5/2021 1/8/2021 1/6/2021 1/8/2021 1/2/2021 ClassPrice - OtherFees - CustomeriD - Click to Add $11.00 $5.00 125 $9.00 126 $9.00 127 $9.00 127 $9.00 129 $9.00 130 $9.00 101 $9.00 105 $9.00 110 $10.00 112 $10.00 114 $9.00 115 $9.00 116 $9.00 117 $9.00 118 32 33 40 20 11 Navigation Pane 2100035 2100036 2100037 2100038 2100039 12 13 31 ** Record: 1 of 39 No Filter Search Datasheet View Type here to search o > Num Lock 11:31 PM 3/3/2021 6 19
