Question: a) Write a SQL statement to create a table called tvShows' with tvShow_id showName, network, start date, and genre. b) Write a SQL statement that

 a) Write a SQL statement to create a table called tvShows'

a) Write a SQL statement to create a table called tvShows' with tvShow_id showName, network, start date, and genre. b) Write a SQL statement that will show all the fields in the table you created in 'a' (the problem you just did, above) Write 10 SQL statements that will add the following record and 9 more that you create c) tvShow id showName Network Start dateGen Seasons Atlanta FX 9/6/2016 Comedy 2 d) Write the SQL statement that will display all the fields for all records in the tvShows' table c) Write the SQL statement that displays showName and Scasons (only those 2 fields) and sorts by seasons, from highest to lowest (descending order) Write a SQL statement that display all TV Shows that started September 21, 2014 and December 31,2016 g) Write the SQL statement that displays all the fields for all TV Shows that start with the letter 'A h) Write the SQL statement that will show al the tables you have created. Be sure to use spool on and off

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!