GO16_AC_CH02_GRADER_2G_AS- Concerts and Sponsors

profileHaafi C
go_a02_grader_a3_concerts_sponsors.accdb
Concert ID Concert Name Box Office Receipts Date Concert Location Sponsor ID
EVENT-101 Spring Fling ¤ 1,200.00 5/1/19 Austin City Center SPONSOR-101
EVENT-102 Pride of Texas ¤ 575.00 6/15/19 Texas Arts Center SPONSOR-101
EVENT-103 Blues Festival ¤ 500.00 9/10/19 Austin City Center SPONSOR-102
EVENT-104 Spirit of the Capital ¤ 400.00 Austin City Center SPONSOR-104
EVENT-105 Spanish Carols and Candles ¤ 2,000.00 12/15/19 Georgetown Community Theater SPONSOR-107
EVENT-106 Jazz Alley Live ¤ 400.00 9/30/19 Austin City Center SPONSOR-106
EVENT-107 Showtime Show Tunes ¤ 1,900.00 11/18/19 Georgetown Community Theater SPONSOR-107
EVENT-108 Oldies Concert ¤ 2,000.00 1/16/19 Georgetown Community Theater SPONSOR-108
EVENT-109 Bluebell Festival ¤ 1,000.00 10/20/19 Georgetown Community Theater SPONSOR-103
EVENT-110 Cowboy Hospitality Tour ¤ 800.00 Austin City Center SPONSOR-103
EVENT-111 Texas Trail Songs ¤ 500.00 4/20/19 Austin City Center SPONSOR-105
EVENT-112 Valentine Love Songs ¤ 600.00 2/14/19 Texas Arts Center SPONSOR-101
EVENT-113 Fall Jazz Festival ¤ 950.00 10/30/19 Georgetown Community Theater SPONSOR-101
EVENT-114 State Fair Concert ¤ 2,500.00 8/15/19 State Fairgrounds SPONSOR-104
EVENT-115 Winter Jazz Festival ¤ 975.00 1/23/19 Austin City Center SPONSOR-101
EVENT-116 Thanksgiving Festival ¤ 500.00 11/24/19 State Fairgrounds SPONSOR-104
EVENT-117 History of Blues ¤ 675.00 3/15/19 Texas Arts Center SPONSOR-101
ID mSysRowId
1 RRgWS5CjUNhnBQVQrBY0ZLaQM3WSTd4SbRtsYM7Xhhc=-~On8N2EZ8JJrK4sqbyRpa0g==
Sponsor ID Sponsor Name Phone Number Web Address mSysRowId
SPONSOR-101 KAUS Radio Station (512) 555-0888 www.kaus.rad R3XCNsA0BDppTPTlkzBZD8rqykFAsTANA38a0lQIJhw=-~2U6SZ63PcLKtLV24GyLR4Q==
SPONSOR-102 Austin Memorial Foundation (512) 555-0557 www.austinmf.com MJ4yOeoS5Ac6JKVW3Xo38kAl47+RQ+rVo8wxq87rhuk=-~sBKH9priL9enM3TYjuLBlw==
SPONSOR-103 Round Rock Chamber of Commerce (512) 555-0077 www.rrcc.biz av9ltiQDbgXhv3scq0lnur3pKuqxEc3zrSGQhv3vmyM=-~SZyDDM5w79o/larihILfMg==
SPONSOR-104 Georgetown Booster Club (512) 555-3346 www.georgetownbc.com kqYMASGxrIDw80qSxaGRSH8unzhKcxYHCQmHui0guw4=-~XWwf2irxFP2iAMHKCQE/4Q==
SPONSOR-105 Texas Lakes CC Foundation (512) 555-0090 www.tlcc.edu/foundation /X72g4vGoUpGfXX0WLN/3BhSlKuZuSisaVI8eaHjFWk=-~m6TAoWL9djepbdxMABwaLQ==
SPONSOR-106 Bank of Texas (512) 555-0666 www.botexas.com g72H4EVyfTcwacB4DuezupRVmOW4Z3YvOG+tBP5+kKg=-~ZQgiQiG9pqnBBgcnW4FbWQ==
SPONSOR-107 Dripping Springs City (512) 555-0323 www.codsprings.gov bge6Z6x1QSD3R/jAAU0Du0ESUYQLz0eeieBVg0gAaAo=-~6osC+mXXBjfjzJCdlcX/nA==
SPONSOR-108 KCEM Radio Station (512) 555-0444 www.kcem.rad poH114YrS3v1pm+hpxyT/JLBL5RMMrElXJhjjC94oHY=-~ZXJeNRT0fhdeAt/rp4SDaw==
SELECT Concerts.[Concert Name], Concerts.[Box Office Receipts], Concerts.[Concert Location] FROM Concerts WHERE (((Concerts.[Box Office Receipts])>=1000)) ORDER BY Concerts.[Concert Location];