No School

AA 1

Database Programming with SQL 15-3: Managing Views Practice Activities Objectives • Create and execute a query that removes a view • Create and execute a query using an inline view • Create and execute a top-n-analysis query Vocabulary Identify the vocabulary word for each definition below. -N analysis Asks for the N largest or smallest values in a column DROP function Removes a view The inline view Subquery with an alias that can be used within a SQL statement Try It / Solve It 1. Create a view from the copy_d_songs table called view_copy_d_songs that includes only the title and artist. Execute a SELECT * statement to verify that the view exists. CREATE OR REPLACE VIEW view_copy_d_songs AS SELECT title, artist FROM copy_d_son