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.