in sqlite$3$ for python i need:g$.[6$ points$]$ Creating views. Create a view $($virtual table$)$ called good$\_$collaboration that lists pairs of actors who have had a good collaboration as defined here. Each row in the view describes one pair of actors who appeared in at least $2$ movies together AND the average score of these movies is $>=40.$

The view should have the format:

good$\_$collaboration$($

cast$\_$member$\_$id$1,$

cast$\_$member$\_$id$2,$

movie$\_$count,

average$\_$movie$\_$score$)$

For symmetrical or mirror pairs, only keep the row in which cast$\_$member$\_$id$1$ has a lower numeric value. For example, for ID pairs $(1,2)$ and $(2,1),$ keep the row with IDs $(1,2).$ There should not be any $$self$-$pair$$ where the value of cast$\_$member$\_$id$1$ is the same as that of cast$\_$member$\_$id$2.$

Remember that creating a view will not produce any output, so you should test your view with a few simple select statements during development. One such test has already been added to the code as part of the auto$-$grading.