CREATE VIEW Accounts ( Title, Advance, [Amount Due] ) 
AS 
SELECT title, advance, price * royalty * ytd_sales 
   FROM titles