5 of 5
Question 7:
Paper No: 1
[1] Write a query to display all the names of the location that host the most events.
Results
Name
Messages
1
City Park
Picture 7.1
Question 8:
[1] Write a query to insert multiple new staff members into the Staffs table with their names and phone numbers as follow:
name = 'John Doe', phone '555-987-6543'
name 'Jane Smith', phone= '555-654-3210'
name = 'Alice Brown', phone = '555-123-7890'
Question 9:
[1] Write a query to update the phone number of staff members based on specific conditions.If the current phone number starts with '555', change it to '999', otherwise leave it unchanged.
Question 10:
[11 Create stored procedure named proc Staffs with the following parameters: Staffin
+ 100%
Zoom
Close
