Write these SQL views given this schema using CREATE VIEW statement:

The KevinBacon view is a table of the name of each actor that has been cast in a movie with Kevin Bacon, along with a count of the number of times they have been cast with Kevin Bacon.

The Popularity view is a table of the ID, name, and composite score of each actor. The composite score is the sum of the score * votes for every movie the actor has been cast.

Movie (MoviclD, Title, Year, Score, Votes) Actor(ActorlD, Name) Casting (MoviclD, ActorlD, Ordinal)