Zoom
Question 5:
Picture 4.1
[1] Write a query to select event names, location names, and the staff member names working on each event.
EventName
LocationName
StaffName
1
Annual Tech Conference
Convention Center
Alice Johnson
2
Annual Tech Conference
Convention Center
Bob Smith
3
Art Festival
Art Gallery
Cathy Brown
4
Art Festival
Art Gallery
David Wilson
5
Community Picnic
City Park Sports Stadium
Eva White
6
Sports Championship
Frank Black
7
Theatre Performance
City Theatre
Grace Green
8
Book Fair
Library
Henry Blue
9
Music Concert
Convention Center
Isabel Red
10
Film Festival
Art Gallery
Jack Gray
11
Holiday Market
City Park
Kathy Pink
12
Career Fair
University Auditorium
Leo Orange
13
Charity Run
Community Hall
Mona Purple
14
Cultural Festival
Town Square
Nina Cyan
15
Science Exhibition
Expo Center City Park
Oscar Magenta Alice Johnson
16
Food Truck Festival
Picture 5.1
Question 6:
[1] Write a query to select events that have more than 1 staff member assigned. The information displayed is as follows:
eventID name
1
2
2
StartTime
End Time
locationID
Annual Tech Conference
2024-10-01 09:00:00.000 2024-10-01 17:00:00.000 LOC001
Art Festival
2024-11-15 10:00:00.000
2024-11-15 18:00:00.000 LOC003
+ 100%
Picture 6.1
Close