SQL CODE $($dbeaver$)$ The table is called movies. Column names are MovieID, title, and genres.vCreate a new table called Movies$1.$ This new table should have all the

information that table Movies has plus $1$ 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.

$7.(5$ pts$)$ Use group by to count how many scary or funny movies are in table

Movies$1.$