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];