select BName Count,InPrice*Count as RestPrice from Book //Problem 3 select Date,SUM(Count*Price) as TotalMoney from Sale group by Date //Problem 4 select BName,Count,Count*Price as TotalMoney,Date from Book,Sale where Book.BNo=Sale.BNo //Problem 5 select BName,Count from Book,Sale w...
First, the ANOVA summary table is selected internally. The first select statement in the script excerpt below captures the ANOVA summary table info. Second, the code block looks up the critical HSD values for the .01 and .05 alpha levels. This tip relies on just t...