Solve the sql questions for me. I already done 8,9.

What I have is two views, I need you to solve 10 for me. What you need to do is just divide view from 8 by 9.

So views from 8 and 9:

8.CREATE VIEW win_gamea AS SELECT count(*) AS "Totala" from football_games where home_score > visitor_score; 9.CREATE VIEW all_gamesa AS SELECT count(visitor_name) AS "Total2" from football_games;

8. Write a script to create a view that counts the total number of winning games 9. Write a script to create a view that counts the total number of games played. 10. Write a script that uses the two views you created (from 8 &9) to calculate the percent of wins