Create the query from question using view instead cte

• num_desks   (number of desks in the order)

2. Create a query that uses a Common Table Expression (CTE) and a Window Function to get the following columns:

5. Create a role named “product_administrator” with permissions to SELECT and INSERT records into the product table.   Create a user named “bob finance” who is a member of that role.