8.10. CREATE VIEW The optional clause causes the view to be replaced if italready exists rather than raising an error. Create a view that summarizes : DROP VIEW,