Task # 1 a. We need to create a table that will store the most popular TV shows. Here is some sample data that represent
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Task # 1 a. We need to create a table that will store the most popular TV shows. Here is some sample data that represent
statement to show all records 2017 Genre Comedy Drama Drama Sci-Fi b. There was a mistake in the score released for Stranger Things. Change the score to 6. Score c. Update all the Networks that have HBO and change it to Netflix using the LIKE operator 7 b. Create a table that will store this data. Use the most appropriate data types. Provide a copy of the SQL statement Using the INSERT statement add ALL the information to this table. Note: If an important column is missing, don't forget to create it 8 9 a. There was a mistake made to one of the records. Using the UPDATE statement, change GAME OF THRONES to WEST WORLD. 8
Task # 1 a. We need to create a table that will store the most popular TV shows. Here is some sample data that represents what we need to store: Title American Horror story The Walking Dead Game of Thrones Stranger Things Task #2 Network HBO AMC HBO Netflix Year Released 2016 2010 2011 Task #3 Run a SELECT