Zoom
Picture 1.1
Question 2:
3 of 3
Paper No: 1
[0.5]Write a query to select all events that start after a specific date (e.g., January 1, 2024)from the Events table as follows:
eventID name
StartTime
EndTime
locationID
1
1
2
2
3
3
Community Picnic
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
2024-12-05 12:00:00.000 2024-12-05 16:00:00.000
LOC002
4
4
Sports Championship
2025-01-20 14:00:00.000 2025-01-20 20:00:00.000 LOC005
5
5
Theatre Performance
2025-02-10 19:00:00.000
2025-02-10 21:00:00.000 LOC011
6 6
Book Fair
2025-03-15 10:00:00.000
2025-03-15 18:00:00.000 LOC007
7
7
Music Concert Film Festival
2025-04-30 20:00:00.000 2025-04-30 23:00:00.000 LOC001
8
8
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
Charity Run
2025-08-25 07:00:00.000
2025-08-25 10:00:00.000 LOC004
12 12
Cultural Festival
2025-09-12 10:00:00.000
2025-09-12 18:00:00.000 LOC006
13 13
Science Exhibition
2025-10-05 09:00:00.000
2025-10-05 17:00:00.000 LOC013
14 14
Food Truck Festival
2025-11-18 11:00:00.000 2025-11-18 21:00:00.000 LOC002
15 15
New Year Gala
2025-12-31 20:00:00.000
2026-01-01 01:00:00.000 LOC010
Picture 2.1
Question 3:
+ 100%
Close
