Answered step by step
Verified Expert Solution
Link Copied!

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! image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions