Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SQL CODE ( dbeaver ) The table is called movies. Column names are MovieID, title, and genres.vCreate a new table called Movies 1 . This
SQL CODE dbeaver The table is called movies. Column names are MovieID, title, and genres.vCreate a new table called Movies This new table should have all the
information that table Movies has plus additional column. This additional
column should say funny if a movie is listed as Comedy, or scary if the movie
is either Thriller or Horror. Leave it as NULL if the movie is neither.
pts Use group by to count how many scary or funny movies are in table
Movies
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started