Completed
Incomplete
Not Attended
Share
A wedding planning service needs to manage the list of events, vendors, and guest lists for weddings. You need to create the database schema, add details, and query for wedding plans.
Question - 1Add a new event 'Sangeet' scheduled for '2024-12-13' at 'Royal Banquet Hall'.
Question - 2Update 'Reception' location to 'Luxury Palace Hotel'.
Question - 3List all vendors that provide 'Catering' services.
Question - 4Retrieve all events sorted by date in ascending order.
Question - 5Find all events that are scheduled to take place in 'Beachside Resort'.
Code Editor
Table Name: events
| id | event_name | date | location |
|---|---|---|---|
| 1 | Reception | 2024-12-15 | Grand Palace Hotel |
| 2 | Mehendi | 2024-12-14 | Beachside Resort |
Table Name: vendors
| id | vendor_name | service_type |
|---|---|---|
| 1 | Catering Co. | Catering |
| 2 | Floral Arrangements | Decor |
Table Name: guests
| id | guest_name | event_id |
|---|---|---|
| 1 | Amit Sharma | 1 |
| 2 | Sneha Patel | 2 |
>>> Submit Your Query to validate