11 Holiday Market
City Park
Kathy Pink
12 Career Fair
13
Charity Run
University Auditorium
Leo Orange
Mona Purple
14 Cultural Festival
Community Hall
Town Square
Nina Cyan
15 Science Exhibition
Expo Center
Oscar Magenta
16 Food Truck Festival
City Park
Alice Johnson
Question 6:
Picture 5.1
[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
StartTime
Annual Tech Conference 2024-10-01 09:00:00.000
locationID
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
1
2
5 of 5
Picture 6.1
End Time
Paper No: 1
Question 7:
[1] Write a query to display all the names of the location that host the most events.
Results
Messages
Zoom
Name
+ 100%
Close
