an aggregate may not appear in the where clause unless it is in a subquery contained in a having clause or a select list, and the column being aggregated is an outer reference.

Kinkead inc. forecasts that its free cash flow in the coming year, i.e., at t = 1, will be −$10 million, but its fcf at t = 2 will be $20 million. after year 2, fcf is expected to grow at a constant rate of 4% forever. if the weighted average cost of capital is 14%, what is the firm's value of operations, in millions?

You and your new australian bride matilda, are applying for a loan and are required to submit a balance sheet with your net worth. you own a 2008 toyota camry that you bought last month for $9,995. the kelly blue book value for this car is $13,995. you owe $8,150 on the car loan for the camry. you pay off your visa credit card every month and have not paid any credit card interest this year. the current visa credit card balance is $3,522, and the next statement is due in 15 days. you have a student loan balance of $6,500. you presently have $425 in your checking account and $1,540 in your savings account. you own 100 shares of ibm stock that you purchased for $85.50 per share. one share of ibm is now selling for $158.42. you own computers and other electronics that you purchased for $4,100 but could probably sell today on e-bay for $1,800. your gross income is $80,000 per year. what is your current net worth? (see wb ch. 2 example 2.3)

When the national economy goes from bad to better, market research shows changes in the sales at various types of restaurants. projected 2011 sales at quick-service restaurants are $164.8 billion, which was 3% better than in 2010. projected 2011 sales at full-service restaurants are $184.2 billion, which was 1.2% better than in 2010. how will the dollar growth in quick-service restaurants sales compared to the dollar growth for full-service places?