Instantly share code, notes, and snippets.
JonathanCass / movies.sql
- Download ZIP
- Star ( 0 ) 0 You must be signed in to star a gist
- Fork ( 0 ) 0 You must be signed in to fork a gist
- Embed Embed this gist in your website.
- Share Copy sharable link for this gist.
- Clone via HTTPS Clone using the web URL.
- Learn more about clone URLs
- Save JonathanCass/7c2f530455e806167147fe7be04c9709 to your computer and use it in GitHub Desktop.
select * from movies; | |
select title, movieid | |
from movies | |
limit 10; | |
select title, movieid | |
from movies | |
where movieid = 485; | |
select movieid | |
from movies | |
where title ='Made in America (1993)'; | |
select title | |
from movies | |
order by title asc | |
limit 10; | |
select title | |
from movies | |
where title like '%2002%'; | |
select title | |
from movies | |
where title like '%Godfather, The%'; | |
select title, genres | |
from movies | |
where genres like '%Comedy%'; | |
select title, genres | |
from movies | |
where genres like '%Comedy%' and title like '%(2000)%'; | |
select title, genres | |
from movies | |
where lower(title) like '%death%' and genres like '%Comedy%'; | |
select title | |
from movies | |
where (title like '%(2001)%' or title like '%(2002)%') and lower(title) like '%super%'; | |
select m.title, r.rating | |
from movies m | |
left join ratings r on m.movieid = r.movieid | |
where m.title like '%Godfather, The%'; | |
select m.title, r.rating, r.timestamp | |
from movies m | |
left join ratings r on m.movieid = r.movieid | |
where m.title like '%Godfather, The%' | |
order by r.timestamp desc; | |
select m.title, l.imdbid | |
from movies m | |
left join links l on m.movieid = l.movieid | |
where m.title like '%2005%' and m.genres like '%Comedy%'; | |
select m.title, r.rating | |
from movies m | |
left join ratings r on m.movieid = r.movieid | |
where r.movieid IS NULL; | |
SELECT movies.title, movies.genres | |
FROM movies | |
JOIN movie_genre | |
ON movie_genre.movieid = movies.movieid | |
JOIN genre | |
ON genre.id = movie_genre.genre_id | |
WHERE genre.genres ='Fantasy'; | |
select concat('http://www.imdb.com/title/tt', links.imdbid) as link, movies.title | |
from links | |
join movies on links.movieid = movies.movieid; | |
select concat('https://www.themoviedb.org/movie/', links.tmdbid) as link, movies.title | |
from links | |
join movies on links.movieid = movies.movieid; |
Vasundhara Kadekodi Portfolio
Marketing and retail-analytics.
π°ποΈπ Reduce costs and increase revenue with OList E-commerce Inventory Management! ππ Using Pareto analysis and market basket analysis, we identify top-performing products and customer purchase behavior to optimize inventory and prioritize profitable categories. ππ‘ Our recommendations include focusing on top-performing products, creating product bundles, and removing slow-moving items from categories. πͺ
- View Project
Resume Screening
ππ Traditional manual resume screening is time-consuming and prone to biases. But, π€ machine learning models can automate the process, leading to a more efficient and objective screening process. In this project, we preprocess the data to extract relevant features, analyze it using various ML techniques, and build models to predict the category of each resume based on job requirements. The models are evaluated using performance metrics, and the insights are used to improve the screening process. ππ‘π¨βπ»
Bike Sharing A Machine Learning Model
Multiple linear regression π was performed on the Boombikes bike rental dataset to find the number of rentals issued π΄ based on various independent values such as temperature π‘οΈ, weather π€οΈ, and holidays ποΈ. The R-squared value suggests a good model, with temperature π‘οΈ, light rain β, and year π being the top predictor variables. Recommendations include increasing bike availability π² and promotions π during the summer months.
Lead Score A Machine Learning Model
ππ The Lead Score Analysis for X Education π helps to increase enrollment by identifying the most influential factors in converting potential customers into registered students. By analyzing data on site visits, time spent on the site, lead origin, notable activity, and more, the analysis provides actionable insights that can be used to optimize the website and increase conversions. Recommendations include improving the UI/UX, offering discounts π°, and prioritizing the key variables identified in the analysis.
Instagram Analytics in SQL
ππ» In this project, I worked with the Instagram product team to provide insights on user behavior and engagement through SQL fundamentals. ππ₯ I analyzed user data to help the marketing team with campaigns, such as identifying loyal and inactive users and suggesting commonly used hashtags. π‘π Additionally, I provided investor metrics on user engagement and identified fake accounts on the platform.
RSVP Movie Case-Study in SQL
π₯π In this project, I analyzed data from RSVP Movies, an Indian film production company, to provide meaningful insights for their upcoming global movie release in 2022. By analyzing data on past movie releases, I was able to make recommendations and help the company plan their project analytically. This project gave me valuable experience in data analysis and the opportunity to contribute to the success of a major film production company.
IPL Match Visualization
ππ It is an interactive Tableau dashboard to showcase IPL statistics from 2008 to 2017. used two datasets, 'matches.csv' and 'deliveries.csv', to create visualizations for match, player, and team statistics. The dashboard included subcategories such as toss outcome vs match outcome, biggest wins, highest totals, orange and purple cap contenders, and team performance. The end goal is to provide important insights and statistics for an infographic that will be used in a newsletter. ππ¨βπ»
Road Accident Dashboard
ππ The UK road accident dashboard, built with Tableau, provides users with a detailed overview of road accidents in the country. The interactive visualizations enable users to explore the data based on accident severity, region, and road type, as well as track patterns by year. π»π
Covid-19 Data Visualization
ππ An interactive Tableau dashboard for COVID-19 cases worldwide with visualizations and insights on death and infection rates. It also displays data based on geographical areas.
Stroke Prediction
π§ π This project builds a machine learning model to predict stroke likelihood based on risk factors like age, hypertension, and smoking status. We used Python π, Scikit-learn, and several algorithms to build the model and evaluated its accuracy using performance metrics. Our model can help healthcare professionals identify high-risk patients and prevent strokes. πͺπ₯
EDA on Bank Loan Dataset
πΌπ A consumer finance company wants to identify loan default patterns through EDA to make informed decisions and reduce financial risks. ππ We will analyze data and identify strong indicators of default to understand driving factors and utilize this knowledge for risk assessment. π»π€ Research on risk analytics will help us make data-driven decisions to ensure applicants capable of repaying the loan are not rejected.
(+91) 9380581879
IMAGES
VIDEO
COMMENTS
RSVP-Movies-SQL-Assignment. RSVP Movies is an Indian film production company which has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2022. The production company wants to plan their every move analytically ...
You have been provided with the data of the movies that have been released in the past three years. You must analyze the data set and draw meaningful insights that can help them start their new project. You are a data analyst and an SQL expert. You must use SQL to analyze the given data and give recommendations to RSVP Movies based on the insights.
RSVP-Movies-SQL-Assignment. RSVP Movies is an Indian film production company which has produced many super-hit movies. They have usually released movies for the Indian audience but for their next project, they are planning to release a movie for the global audience in 2022. We have been provided with the data of the movies that has been ...
Something went wrong and this page crashed! If the issue persists, it's likely a problem on our side. Unexpected token < in JSON at position 4. keyboard_arrow_up. content_copy. SyntaxError: Unexpected token < in JSON at position 4. Refresh. Explore and run machine learning code with Kaggle Notebooks | Using data from multiple data sources.
SQL-RSVP MOVIES CASE STUDY EXECUTIVE SUMMARY & RECOMMENDATIONS: Based on the insights listed in the IMDB dataset, we can make the following conclusions: In the 'Drama' genre, a total of 1078 films were released in 2019. As a result, RSVP Movies' next project should be in the 'Drama' genre.
So we tried to find out the top director and the top production house who will going to direct the movie and the top 3 actor. As this movie is released by India so top three Indian Actor and Actress also required. Suggestion to RSVP: 1) James Mangold can be hired as the director for RSVP's next project. 2) Mammootty & Vijay Sethupathi Should ...
Domain: Movies Tech Stack: SQLObjective: RSVP Movies plans to produce next movie based on data of highest rated movies released in the past three yearsKey Ac...
Download ZIP. Movie SQL assignment. Raw. movies.sql. This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters.
Provide Insightful data of movies for their New Project - Githubvijayabadam/RSVP-SQL-Assignment
Since RSVP Movies is based out of Mumbai, India also wants to woo its local audience. RSVP Movies also wants to hire a few Indian actors for its upcoming project to give a regional feel. Let's find who these actors could be.*/
RSVP Movie Case-Study in SQL. π₯π In this project, I analyzed data from RSVP Movies, an Indian film production company, to provide meaningful insights for their upcoming global movie release in 2022. By analyzing data on past movie releases, I was able to make recommendations and help the company plan their project analytically.
π½π RSVP Movies Case Study - MYSQL ππ½ Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.
Explore and run machine learning code with Kaggle Notebooks | Using data from RSVP Movies. Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more. OK, Got it. Something went wrong and this page crashed!
RSVP Movies plans a global release in 2022 and seeks data-driven insights. My analysis of their past three years' movies suggests focusing on popular genres like action and drama, casting well-known actors, timing releases during peak seasons, leveraging digital platforms, and implementing global marketing strategies.
RSVP Movies SQL Assignment. Contribute to kavitha1409/SQL-RSVP-Movies development by creating an account on GitHub.
As a data analysis process with SQL knowledge, we 've analysed the past three years'(2017,2018,2019) worth of movie dataset for RSVP Movies, an Indian film production company known for its super-hit movies. - ANKIT21111/RSVP-MOVIES-DATA-ANALYSIS.
RSVP Movies assignment based upon IMDb dataset. RSVP Movies assignment based upon IMDb dataset. Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more. OK, Got it. Something went wrong and this page crashed! If the issue persists, it's likely a problem on our side. ...
Analyzing IMDB dataset for RSVP movies case study. Analyzing IMDB dataset for RSVP movies case study. Kaggle uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more. OK, Got it. Something went wrong and this page crashed! If the issue persists, it's likely a problem on our side. ...
RSVP Movies SQL Assignment. Contribute to kavitha1409/SQL-RSVP-Movies development by creating an account on GitHub.
Find and fix vulnerabilities Codespaces. Instant dev environments
Find and fix vulnerabilities Codespaces. Instant dev environments
Find and fix vulnerabilities Codespaces. Instant dev environments
RSVP Movies plans a global release in 2022 and seeks data-driven insights. My analysis of their past three years' movies suggests focusing on popular genres like action and drama, casting well-known actors, timing releases during peak seasons, leveraging digital platforms, and implementing global marketing strategies. ...