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/18 | Austin City Center | SPONSOR-101 |
| EVENT-102 | Pride of Texas | ¤ 575.00 | 6/15/18 | Texas Arts Center | SPONSOR-101 |
| EVENT-103 | Blues Festival | ¤ 500.00 | 9/10/18 | 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/18 | Georgetown Community Theater | SPONSOR-107 |
| EVENT-106 | Jazz Alley Live | ¤ 400.00 | 9/30/18 | Austin City Center | SPONSOR-106 |
| EVENT-107 | Showtime Show Tunes | ¤ 1,900.00 | 11/18/18 | Georgetown Community Theater | SPONSOR-107 |
| EVENT-108 | Oldies Concert | ¤ 2,000.00 | 1/16/18 | Georgetown Community Theater | SPONSOR-108 |
| EVENT-109 | Bluebell Festival | ¤ 1,000.00 | 10/20/18 | 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/18 | Austin City Center | SPONSOR-105 |
| EVENT-112 | Valentine Love Songs | ¤ 600.00 | 2/14/18 | Texas Arts Center | SPONSOR-101 |
| EVENT-113 | Fall Jazz Festival | ¤ 950.00 | 10/30/18 | Georgetown Community Theater | SPONSOR-101 |
| EVENT-114 | State Fair Concert | ¤ 2,500.00 | 8/15/18 | State Fairgrounds | SPONSOR-104 |
| EVENT-115 | Winter Jazz Festival | ¤ 975.00 | 1/23/18 | Austin City Center | SPONSOR-101 |
| EVENT-116 | Thanksgiving Festival | ¤ 500.00 | 11/24/18 | State Fairgrounds | SPONSOR-104 |
| EVENT-117 | History of Blues | ¤ 675.00 | 3/15/18 | Texas Arts Center | SPONSOR-101 |
| ID | mSysRowId |
| 1 | P2LJqpUw0iWHatpQHFY3gND857VJs+k7eBQFrtjl7Ss=-~h+wSkYQOG+08CVS0lJSeiA== |
| Sponsor ID | Sponsor Name | Phone Number | Web Address | mSysRowId |
| SPONSOR-101 | KAUS Radio Station | (512) 555-0888 | www.kaus.rad | k0DsX/j7ZKAtT27l/Pws2GwKt5yexCIlKxdoCrnW4Nw=-~ZFChYZFH8hFnVeaA9NMWXA== |
| SPONSOR-102 | Austin Memorial Foundation | (512) 555-0557 | www.austinmf.com | SwHmuvtC+Pnbf0d9w9vZkJO3sKWCxTk7TXafzJ7xn6k=-~nQNV8mP0wTSDKnAyfa7ABA== |
| SPONSOR-103 | Round Rock Chamber of Commerce | (512) 555-0077 | www.rrcc.biz | ClS95N0D9/1yCK9tCErZct0LAJG9pAx2muyVP5X0ZxM=-~pPGd+BURbWNqzrNdKkk3Lg== |
| SPONSOR-104 | Georgetown Booster Club | (512) 555-3346 | www.georgetownbc.com | yAjSeRpGPvzckJ58LDA0DJVK3jpWjFHnV9OS1ebFQXQ=-~gNfGmpLHtm0tNWWVxaVuRQ== |
| SPONSOR-105 | Texas Lakes CC Foundation | (512) 555-0090 | www.tlcc.edu/foundation | qpAv1ZeZcleyI8PyZRPqq3t3hlBAYGpUWau/ABY4HiA=-~RsjM/05pCIpII/6Y2+FADg== |
| SPONSOR-106 | Bank of Texas | (512) 555-0666 | www.botexas.com | LQRoNVrX3HhZLZhsztPg/hz1SkzW5nwFc4IYnoybt/s=-~FFdzHB/B4BWGwqGc2XGQkw== |
| SPONSOR-107 | Dripping Springs City | (512) 555-0323 | www.codsprings.gov | LwgDGomUQnRAKScSLTf0/2MEAmLafF5Nq+TfiL+oK/8=-~DaK8oV5az7HydZUIdG9j/w== |
| SPONSOR-108 | KCEM Radio Station | (512) 555-0444 | www.kcem.rad | YSO6mBEqyLodjhHVVYMxvlnjJG6vaLNd3NVxNXWOXe0=-~o0+XYVg3iWhcQguMJhxIxg== |
SELECT Concerts.[Concert Name], Concerts.[Box Office Receipts], Concerts.[Concert Location]
FROM Concerts
WHERE (((Concerts.[Box Office Receipts])>=1000))
ORDER BY Concerts.[Concert Location];
Rico79
