Write an SQL statement to create an SQL view named Popular Shows View that has SLIDE_SHOW.Name and PICTURE. Name for all slide shows that have a Purpose of either 'Home' or 'Pets'. Execute this statement using the Microsoft SQL Server Management Studio. Run an SQL SELECT query in the Microsoft SQL Server Management Studio GUI tools to demonstrate that the view Popular Shows View was constructed correctly.