Hackathon Questions
-
A customer with Email : nicoleanderson@hotmail.com has forgotten their username, please help them find it using sample_analytics.customers.
-
In sample_mflix.movies, what is the runtime of the movie title “The Kid Brother”?
-
What is the transaction count where account_id is greater than 183500 and less than 184000? Find it using sample_analytics.transactions.
-
You are tasked to check a random customer satisfaction rating. Using sample_supplies.sales find the satisfaction rating of customer having email : kave@we.com.
-
In sample_training.posts, how many posts have title as “Bill of Rights” ?
-
Using sample_training.zips, find the location coordinates of the city CLEVELAND where the population is between 500 and 1000.
-
In sample_training.trips, sort the trips in decreasing order and tell the first 2 start station names.
-
You are starting a restaurant in Bronx and want to know the number of different cuisines being served in the area.
Find it using “sample_restaurants.restaurants”. -
Using sample_training.inspections, find the business_name where zip is greater than 11400 and less than 11500 in City “JAMAICA” and certificate_number ending with 9453.
-
You are going on a trip with a friend and looking for a place to stay. Using sample_airbnb.listingsAndReviews, find the name of the place where the price should be less than 60 and the number of reviews should be greater than 300, should accommodate 2 people only with no security deposit and the room type should be a Private room with minimum nights equal to 2.