Question

Section B - SQL DML (UPDATE, DELETE, INSERT) Question 1 Task Due to significant Olympic developments, car traffic in Woolloongabba is heavily restricted for the month of May 2023. Delete the attendee registration for anybody using a car to attend an event at 'The Gabba' in May. Explanation To identify events held at 'The Gabba' you should check for the presence of 'gabba' within the event location. MONTH Function YEAR Function LOWER Function SQL Solution

          Section B - SQL DML (UPDATE, DELETE, INSERT)
Question 1
Task
Due to significant Olympic developments, car traffic in Woolloongabba is
heavily restricted for the month of May 2023. Delete the attendee registration for
anybody using a car to attend an event at 'The Gabba' in May.
Explanation
To identify events held at 'The Gabba' you should check for the presence of
'gabba' within the event location.
MONTH Function
YEAR Function
LOWER Function
SQL Solution

Section B - SQL DML (UPDATE, DELETE, INSERT)
Question 1
Task
Due to significant Olympic developments, car traffic in Woolloongabba is
heavily restricted for the month of May 2023. Delete the attendee registration for
anybody using a car to attend an event at 'The Gabba' in May.
Explanation
To identify events held at 'The Gabba' you should check for the presence of
'gabba' within the event location.
MONTH Function
YEAR Function
LOWER Function
SQL Solution

Added by Silvia H.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Aarya B

06/02/2023

Step 1

To do this, we can use the following SQL query: ```sql SELECT * FROM events WHERE event.location LIKE '%The Gabba%' AND MONTH(event.date) = 5 AND YEAR(event.date) = 2023; ``` Show more…

Show all steps

Thanks for your feedback!

Texts: Section B - SQL DML (UPDATE, DELETE, INSERT) Question 1 Task: Due to significant Olympic developments, car traffic in Woolloongabba is heavily restricted for the month of May 2023. Delete the attendee registration for anybody using a car to attend an event at 'The Gabba' in May. To identify events held at 'The Gabba', you should check for the presence of 'The Gabba' within the event.location. Explanation: MONTH Function YEAR Function LOWER Function SQL Solution: