7
7
Music Concert
2025-04-30 20:00:00.000
2025-04-30 23:00:00.000 LOC001
8
8
Film Festival
2025-05-20 18:00:00.000
2025-05-20 22:00:00.000 LOC003
9
9
Holiday Market
2025-06-15 10:00:00.000
2025-06-15 20:00:00.000 LOC002
10 10
Career Fair
2025-07-10 09:00:00.000
2025-07-10 15:00:00.000 LOC008
11
11
Charity Run
2025-08-25 07:00:00.000
2025-08-25 10:00:00.000 LOC004
12 12
Cultural Festival
13 13
Science Exhibition
14 14
Food Truck Festival
15 15
New Year Gala
2025-09-12 10:00:00.000
2025-09-12 18:00:00.000 LOC006
2025-10-05 09:00:00.000
2025-10-05 17:00:00.000 LOC013
2025-11-18 11:00:00.000
2025-11-18 21:00:00.000 LOC002
2025-12-31 20:00:00.000
2026-01-01 01:00:00.000 LOC010
Zoom
Question 3:
Picture 2.1
[0.5]Write a query to count the total number of events scheduled at each location. The information displayed is as follows:
locationID
TotalEvents
1
LOC001
2
2
LOC002 3
3
LOC003
2
4
LOC004 1
5
LOC005 1
6
LOC006 1
7
LOC007 1
8
LOC008 1
9
LOC010 1
10 LOC011 1
11
LOC013 1
Picture 3.1
Question 4:
[1]Write a query to get events with at least 2 staff members executing them.
+ 100%
Close
