deficit is the amount by which a sum of money falls short of the required or expected amount.()
第1题:
7、BookStore数据库中有销售明细表OrderDetail(OrderCode, BookCode, Amount) 查询销售总量前20%的图书,并按总销量降序排列。SQL语句: SELECT TOP 20 PERCENT Bookcode As 书号, SUM(Amount)As总销量 ROM OrderDetail GROUP BY Bookcode ORDER BY ________
A.Amount DESC
B.SUM(Amount) DESC
C.COUNT(Amount) DESC
D.ADD(Amount) DESC
第2题:
【简答题】银行存款本息的计算。 输入存款金额 money、存期 year 和年利率 rate,根据公式计算存款到期时的本息合计sum(税前),结果保留2位小数。 sum = money (1 + rate)year 注:幂函数ax用库函数pow(a,x)。
第3题:
【单选题】BookStore数据库中有销售明细表OrderDetail(OrderCode, BookCode, Amount)查询销售总量前20%的图书,并按总销量降序排列。SQL语句: SELECT TOP 20 PERCENT Bookcode As 书号, SUM(Amount)As总销量 ROM OrderDetail GROUP BY Bookcode ORDER BY ________
A.Amount DESC
B.SUM(Amount) DESC
C.COUNT(Amount) DESC
D.ADD(Amount) DESC
第4题:
BookStore数据库中有销售明细表OrderDetail(OrderCode, BookCode, Amount) 查询销售总量前20%的图书,并按总销量降序排列。SQL语句: SELECT TOP 20 PERCENT Bookcode As 书号, SUM(Amount)As总销量 ROM OrderDetail GROUP BY Bookcode ORDER BY ________
A.Amount DESC
B.SUM(Amount) DESC
C.COUNT(Amount) DESC
D.ADD(Amount) DESC
第5题:
查询图书“神曲”的销售总量及销售总额。语句如下: SELECT BookName AS 书名, Sum(Amount) AS 销售总量, Sum(TotalPrice) AS 销售总额 FROM Book JOIN OrderDetail ON Book.BookCode=OrderDetail.BookCode JOIN [Order] ON OrderDetail.OrderCode=[Order].OrderCode GROUP BY BookName HAVING _________
第6题:
写出下面代码的运行结果。def addInterest(balance,rate): newBalance=balance*(1+rate) balance=newBalance def main(): amount=1000 rate=0.05 addInterest(amount,rate) print (amount) main()