EventBrite

Eventbrite is an American event management and ticketing website. The service allows users to browse, create, and promote local events.Therfore the task is to analyze the Eventbrite Analytics (Dataset) and retrieving various informations from it using sql queries. ( **** Writing of simple sql queries using "having clause , group by , where , all, union etc " to the complex ones " using joins and its types , self joins , subqueries, PLSQL etc " ****)

Files Summary :

Download the above EventBrite (zip file) and follow the procedures as bellow 👎

1. File named Dataset.sql contains the complete script for your database.( Includes : all CREATE AND INSERT Queries for all the tables of the database.)
2. File named Queries.sql includes the queries for all the varous questions stated below .
3. File named Outputs.docx contain all the outputs of the queries that are mentioned in the above file named Queries.sql .
4. File named ER DIAGRAM.png contains the Entity Relationship Diagram for the above EventBrite database.

#Requirements: 1.Xampp server 2.phpMyAdmin SQL Dump version 5.0.4 -- Server version: 10.4.17-MariaDB -- PHP Version: 8.0.1

Various Questions to retreive data from the above database ::

1. Count the number of Attendee's Emails for each attendee's arrival status .

2. List the names, email, company of the male attendees in which the sponsor company is Freutz or Bolton .

3. Display bottom five creator's name when Event_ID is arranged in serial wise from smaller to larger.

4. Show the percentage of orders placed in the event .

5. Find the average of the events by Status in ascending order.

6. List down the number of changed for each individual Organizers .

7. Display the category of ticket reservations and find the median of quantity of ticket sold in each category of tickets.

8. Show the names of attendees , gender , ticket category and quantity of ticket sold whose category belongs to RSVP or EarlyBird.

9. Find the customer's name and status of order placed for the event name that starts with Zylker.

10. List the names of attendees , organizer's name and the status of tickets for the event organized by Southern Entertainment .

11. Display the Venue's names , city , state which belong to country 'US ' and the states it belongs may be 'TX' or 'CA'.

12. List down the male attendee's name and Email who have not 'Checked in' and where the company lies in the listed companies list.

13. Show the attendees name and number of order placed where number of order placed is less than or equal to 149.

14. FInd the Quantities of ticket Sold which are having Attendees gender “Male” and Country “US”.

15. List the Attendees Names that are checked in when an event is happening in “AU” and events’s status is “Live” .

16. Display the Team_ID, Event_ID , creator's Email and Name of the Teams whose Events are completed and all tickets are sold out and events held in the United States.

17. List down the Email,Company,Order_ID and Names of Female attendees whose ticket class is “General Admission” and are watching live event in “US”.

18. Display the venue's name and localized address for the event where event changed in between "12-04-2019" to "16-12-2019".

19. Find the event's name, creator's name , organizer's name for which the status is 'LIVE' and the attendees count is less than or equal to 10 .

20. Return the event_ID from both events and orders where event changed is less than or equal to '06-02-2020 15:00'.

21. Display the venue's name and the city where the event is organized in the state 'TX' or 'VIC'.

22. Find the event's name and its organizer and also find the city and the state where the event is held whose event's status is 'completed' or 'live'.

23. Name the attendees and display their email and the company they belong where the status of the attendees is both 'not attending' and 'Checked in'.

24. Display the city and the venue for the event where the Venue_ID is '10270333'. - (Implementation of PLSQL) .

Instructions to run the above SQL queries and PLSQL query :

1. Install XAMPP server on your system to be used as local server for project. (lets say you installed it in 'K:\xampp_folder' folder)
2. Download the zip file and unzip on any of the drive .
3. Start your XAMPP Control Panel and start 'Apache' and 'MySql' servers there.
4. Open your browser and type 'localhost/' or '127.0.0.1/' , then from there go to phpmyadmin.
5. Create a database named:'EventBrite' or you can even name it as of your choice in phpmyadmin.
6. Import the Dataset.sql file which is in the sql directory.
7. Congratulations! you are good to go ....... Try retrieving various informations from the dataset and Explore new advanced queries...... ^-^
8. To implemet plsql query install sqlplus and then run plsql queries through the sql command prompt.
9. First import the sql tables and then type set serveroutput on and write the plsql code and the ouput is displayed for the above PLSQL query.

Thank you