Question: Table names: ['users', 'category', 'date', 'listing', 'venue', 'event', 'sales'] Column names: [('event_id',), ('venue_id',), ('cat_id',), ('date_id',), ('event_name',), ('start_time',)] Question 35 (4 points) Go back to the
Table names: ['users', 'category', 'date', 'listing', 'venue', 'event', 'sales']
Column names:
[('event_id',), ('venue_id',), ('cat_id',), ('date_id',), ('event_name',), ('start_time',)]
![Table names: ['users', 'category', 'date', 'listing', 'venue', 'event', 'sales'] Column names: [('event_id',),](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f3c900aed67_73666f3c90031d15.jpg)
Question 35 (4 points) Go back to the notebook - In section 2 you have all the functions to connect you to the tickets database from homework 3. Given those tables, please write a query that does the following: gets the top five events that have the highest average price per ticket in the listing table. Return just the event_id and the average price per ticket aliased as avg_price Paste your query string in the text box. Question 35 (4 points) Go back to the notebook - In section 2 you have all the functions to connect you to the tickets database from homework 3. Given those tables, please write a query that does the following: gets the top five events that have the highest average price per ticket in the listing table. Return just the event_id and the average price per ticket aliased as avg_price Paste your query string in the text box
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help