9:134 LTE 202102_SQL_Python_Asses. SQL TEST: Background. The site FoxNews.com wants to perform some in-depth analysis on its activities in 2020. FoxNews.com has various pages for users to view as well as videos on the pages that can be played. These Page Views and Video Views are recorded as sits in a SQL database, particularly in the table hit_data below. In addition to the hit_datatable. There are various reference tables that are referenced for analysis. One interesting on the subscribers table, which has user level information on subscribers only. Functions that can be used For date manipulation, you're given the functions DAY[datetime), MONTH(datetime, and YEAR datetime). These functions will output the part of the date timestamp inputted. Assume that they'll give you what you desire (either a date value (MONTH2020-12-17) = 2020-12-01 or an integer (MONTH2020-12-13) - 17. does not matter which you assumel. You can also use any date parsing function available in SOL The tables are defined Table Name: hit data Data To 9:13 4 LTE 202102_SQL_Python_Asses... The tables are defined as: Table Name: hit data Data Field Name Definition date timestame stateme timestamp of the Unique ID for agvenue, whether they are a subscriber or not the eld varchar have a user_id asociated with them type varchar The type of hit Page View or Video Start tid varchar Aunique ID for the nit Unique ID for the Page. Is always present since even video pared varchar played on a pope video_id varchar Unique ID for the video is nul when the hit isa Video Seart Table Name: pages Data Field Name Type Definition pared varchar Unique ID for the Page parane varchar Name of the Page pere type varchar Type of Page Homepage Article Sign in, etc Table Name videos Data Field Name Definition videoid varchar Unique ID for the Video wideo warchar Name of the Video varchar Type of Video Table Name: Subscribers Field Name werd user name first wser name last state_residence Definition Unique User ID for the User and is only availabled the varchar Subscriber varchar First Name User provided on Sign Up varchar Last Name User provided on Sp Lip varchar State of User provided on Sign Up Examples of data in tables Team hed dele simmere type 12/11 Pare Vio HT M 9:134 LTE 202102_SQL_Python_Asses... Table Name wide date.timestament type 1/1/0 Me? Video 32/1/2018 Son pages papeid pare name page_type Fox News CAC842300923820050675849 page HE d3eb1233e5294874007306201 4 Article Name Here Artide videos video id video na 9120803b2249425410684495257 0 Fox News Go video_type Livestream Subscribers user_name_first user_name_fast state residence wer_id 22 1. For the date range 10/15/20/dlpageviews were there? 9:15 LTE 202102_SQL_Python_Asses... 6. How many non subscribers visited the site during May 2007 7. Write a query that would deplay the results below. Note: the month columnaste something that clearly indicates the referred monthlex 1/1/2000, 2/1/2000 ColumnNames do not have to match the columnames below. Month Number of Page Number of Subscribers Views for the month January 2010 D January 2020 1.10 January 2020 11.50 January 2020 51 w February 2000 10 February 2020 February 2020 11-50 February 2020 51. A. List the top 1000 mert other their or finto last name by pageviews for each month 2020 in a single query 9:134 LTE 202102_SQL_Python_Asses. SQL TEST: Background. The site FoxNews.com wants to perform some in-depth analysis on its activities in 2020. FoxNews.com has various pages for users to view as well as videos on the pages that can be played. These Page Views and Video Views are recorded as sits in a SQL database, particularly in the table hit_data below. In addition to the hit_datatable. There are various reference tables that are referenced for analysis. One interesting on the subscribers table, which has user level information on subscribers only. Functions that can be used For date manipulation, you're given the functions DAY[datetime), MONTH(datetime, and YEAR datetime). These functions will output the part of the date timestamp inputted. Assume that they'll give you what you desire (either a date value (MONTH2020-12-17) = 2020-12-01 or an integer (MONTH2020-12-13) - 17. does not matter which you assumel. You can also use any date parsing function available in SOL The tables are defined Table Name: hit data Data To 9:13 4 LTE 202102_SQL_Python_Asses... The tables are defined as: Table Name: hit data Data Field Name Definition date timestame stateme timestamp of the Unique ID for agvenue, whether they are a subscriber or not the eld varchar have a user_id asociated with them type varchar The type of hit Page View or Video Start tid varchar Aunique ID for the nit Unique ID for the Page. Is always present since even video pared varchar played on a pope video_id varchar Unique ID for the video is nul when the hit isa Video Seart Table Name: pages Data Field Name Type Definition pared varchar Unique ID for the Page parane varchar Name of the Page pere type varchar Type of Page Homepage Article Sign in, etc Table Name videos Data Field Name Definition videoid varchar Unique ID for the Video wideo warchar Name of the Video varchar Type of Video Table Name: Subscribers Field Name werd user name first wser name last state_residence Definition Unique User ID for the User and is only availabled the varchar Subscriber varchar First Name User provided on Sign Up varchar Last Name User provided on Sp Lip varchar State of User provided on Sign Up Examples of data in tables Team hed dele simmere type 12/11 Pare Vio HT M 9:134 LTE 202102_SQL_Python_Asses... Table Name wide date.timestament type 1/1/0 Me? Video 32/1/2018 Son pages papeid pare name page_type Fox News CAC842300923820050675849 page HE d3eb1233e5294874007306201 4 Article Name Here Artide videos video id video na 9120803b2249425410684495257 0 Fox News Go video_type Livestream Subscribers user_name_first user_name_fast state residence wer_id 22 1. For the date range 10/15/20/dlpageviews were there? 9:15 LTE 202102_SQL_Python_Asses... 6. How many non subscribers visited the site during May 2007 7. Write a query that would deplay the results below. Note: the month columnaste something that clearly indicates the referred monthlex 1/1/2000, 2/1/2000 ColumnNames do not have to match the columnames below. Month Number of Page Number of Subscribers Views for the month January 2010 D January 2020 1.10 January 2020 11.50 January 2020 51 w February 2000 10 February 2020 February 2020 11-50 February 2020 51. A. List the top 1000 mert other their or finto last name by pageviews for each month 2020 in a single query