Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can anyone help me with those basic SQL and data science questions? thank you so much! You have data on movie reviews located within a
can anyone help me with those basic SQL and data science questions? thank you so much! You have data on movie reviews located within a schema of a database. The first several rows of each table are shown below. 1. Write a query in SQL to find the name of the user with the lowest average rating, as of May 2019 2. Write a query in SQL to find which user/users (their name) have been active for the longest period of time. ID MOVIE_ID MOVIES TITLE Avengers: Endgame Aladdin Aquaman MOVIE RATINGS USER_ID RATING CREATED AT 2019-05-07 00:10:00 2019-04-28 09:00:00 2019-05-11 10:40:00 2019-05-02 09:30:00 2019-06-16 08:00:00 2019-05-30 09:00:00 2019-06-01 13:50:00 2019-01-05 09:56 2019-01-28 10:00:00 USERS NAME Ben Nicole James Tara ID WWNNN Write a working code in SQL which takes information from table 1 (named as "Table_1") and table 2 (named as "Table_2") to produce table 3 (named as "Table_3"). Table 2 Table 1 DistrictID SD001 SD002 SD003 SD004 SD005 Region East West North South East Partnerid P1001 P1002 P1003 Partner Type DistrictID Business SD002 Civic SD003 Business SD004 P1004 P1005 Government SD005 Government SD003 SD006 North Table 3 Dartner Table 3 Total Region East West Partner Type Business Civic Government Business Civic Government Business Civic Government Business Civic North South You are working in a multi-national agency which aims to improve marketing campaign results for its customers. Your team received a large data set (assume 2000 columns and 500 million rows) from one customer. However, the agency's current data processing capacity is not sufficient to train machine learning models on the entire data set. As a data scientist or machine learning engineer, what steps can you take to analyze the data and produce statistical insights from it
can anyone help me with those basic SQL and data science questions? thank you so much!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started