11 LOC013
حمد
1
Picture 3.1
Question 4:
[1]Write a query to get events with at least 2 staff members executing them.
4 of 4
Paper No: 1
The result includes 2 columns: eventID, NumberStaff
Question 5:
eventID
NumberStaff
1
2
2
2
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 Sports Championship
City Park Sports Stadium
Eva White
6
Frank Black
7
Theatre Performance
City Theatre
Grace Green
Zoom
+ 100%
Close
