very simple task…I need to answer 1 question from the database “.db” file that

by Caaltu · May 19, 2024

very simple task…I need to answer 1 question from the database “.db” file that I provided. Use python. show the code and also the output. I need source code and also the output for the question. please use sqlite3 library and python.
question: What ride (note that not all attractions are rides) has the second longest average visit time? It has to be a name of the ride.
Additional Information:
The information contained in each of these tables is listed below:
checkin: – The check-in data for all visitors for the day in the park. The data includes two types of check-ins: inferred and actual checkins.
– Fields: visitorID, timestamp, attraction, duration, type
attraction: – The attractions in the park by their corresponding AttractionID, Name, Region, Category, and type. Regions are from the VAST Challenge map such as Coaster Alley, Tundra Land, etc. Categories include Thrill rides, Kiddie Rides, etc. Type is broken into Outdoor Coaster, Other Ride, Carousel, etc.
– Fields: AttractionID, Name, Region, Category, type
sequences: – The check-in sequences of visitors. These sequences list the position of each visitor to the park every five minutes. If the visitor has not entered the part yet, the sequence has a value of 0 for that time interval. If the visitor is in the park, the sequence lists the attraction they have most recently checked in to until they check in to a new one or leave the park.
– Fields: visitorID, sequence