UPLORER DATAWAREHOUSE PROGRAMMER deploy initial schemasol 02 mpotraw.data. revert 01 inchem 302. impotraw.data > Well README.md O sich.cont Switch plan V 08 11 & Snilt- On initial schema.sal M README.MX 202 morte dates README. This 1 Objective 2 3 Your assignment explores the included "The office" dataset, in the database table named "the office dialog". Your task is to create new tables populated with reporting data on the dataset using SOL scripts. The database is Postores. 4 5 Briat 7 Everyone loves "The Office, a popular show that stred from 2005 to 2013. ile doing research, you stumbled across this dataset, with the lines of all the episodes. You decide to explore the dataset and answer some questions by storing the results in new tables that could easily be used by a t or reporting tool. M 8 9 10 Tasks Your first task is to create new database tables deployment script for your report data. You will work with these tables for the rest of the challenge. It is up to you how to structureame/index/test/document the tables, and how many tables To make 12 13 14 15 10 27 18 19 20 21 27 23 We want you to create tables that can provide pre-computed data and answer for the following ustions - For all data, What are the names of the characters? How many characters are there! - For each season, which character has the most - For each season, what is the number of times a "That's wat she sai joke cones vp? - For each season, what is the average percent of times each character contributed per episode? For each character. what is the average number of words per ne? - For each character, what is the most common word? - For each character, what is the number of episodes were the character does not have a tine Instructions STEP 11 Create your tables/functions by adding deployments to the existing ones in the deploy folder. Adet deployments using the oth command as follo 1 30tch and deploymentines description" 25 26 27 28 29 30 31 Settoyante asenne but without the extension Set description as a brief sentence describing the deployment to consit resse) After running the command, new files will be added to the deploy events and writy' folders STUP i rost the new Files with your SOL code to the table and tries/functions for putting the The deploy script is the SOC WELL crate your changes. You typically le tables, hunctions Insert dat, OUT TIMELINE 33 13 24 25 26 27 28 29 30 31 32 33 34 STEP 1: Create your tables/functions by adding new deployments to the existing ones in the deploy' folder. Add deployments using the soitch add command as follows: sqitch add -- " Well README.md O sich.cont Switch plan V 08 11 & Snilt- On initial schema.sal M README.MX 202 morte dates README. This 1 Objective 2 3 Your assignment explores the included "The office" dataset, in the database table named "the office dialog". Your task is to create new tables populated with reporting data on the dataset using SOL scripts. The database is Postores. 4 5 Briat 7 Everyone loves "The Office, a popular show that stred from 2005 to 2013. ile doing research, you stumbled across this dataset, with the lines of all the episodes. You decide to explore the dataset and answer some questions by storing the results in new tables that could easily be used by a t or reporting tool. M 8 9 10 Tasks Your first task is to create new database tables deployment script for your report data. You will work with these tables for the rest of the challenge. It is up to you how to structureame/index/test/document the tables, and how many tables To make 12 13 14 15 10 27 18 19 20 21 27 23 We want you to create tables that can provide pre-computed data and answer for the following ustions - For all data, What are the names of the characters? How many characters are there! - For each season, which character has the most - For each season, what is the number of times a "That's wat she sai joke cones vp? - For each season, what is the average percent of times each character contributed per episode? For each character. what is the average number of words per ne? - For each character, what is the most common word? - For each character, what is the number of episodes were the character does not have a tine Instructions STEP 11 Create your tables/functions by adding deployments to the existing ones in the deploy folder. Adet deployments using the oth command as follo 1 30tch and deploymentines description" 25 26 27 28 29 30 31 Settoyante asenne but without the extension Set description as a brief sentence describing the deployment to consit resse) After running the command, new files will be added to the deploy events and writy' folders STUP i rost the new Files with your SOL code to the table and tries/functions for putting the The deploy script is the SOC WELL crate your changes. You typically le tables, hunctions Insert dat, OUT TIMELINE 33 13 24 25 26 27 28 29 30 31 32 33 34 STEP 1: Create your tables/functions by adding new deployments to the existing ones in the deploy' folder. Add deployments using the soitch add command as follows: sqitch add -- "