create view someorders (custnum,ocustnum,newprice) as 
	select orders.order_num,items.order_num,
			items.total_price*1.5
		from orders, items
		where orders.order_num = items.order_num
		and items.total_price > 100.00;
