11 Charity Run
Community Hall
12 Cultural Festival
Town Square
13 Science Exhibition
Expo Center
14
Food Truck Festival
City Park
15 New Year Gala
Hotel Ballroom
Question 4:
Picture 3.1
[1]Write a query to get events with at least 2 staff members executing them.
The result includes 2 columns: eventID, NumberStaff
eventID
1
2
NumberStaff
2
2
Question 5:
Picture 4.1
[1] Write a query to get a list of all events along with the total number of staff assigned to each event. The information displayed is as follows:
Zoom
+ 100%
Close