摘要:
SELECT bd.device_no AS 设备编号, SUM(IFNULL(bu.amount,0)) as 总营收, SUM(CASE WHEN bu.is_online = 0 THEN bu.amount ELSE 0 END) as 线上, SUM(CASE WHEN bu.is_online = 1 THEN bu.amount ELSE 0 END) as 线下 FROM... 阅读全文
摘要:
import sys def Collatz(X): print(X) if X % 2 == 0: t = X//2 Collatz(t) elif X == 1: sys.exit() else: t = 3 * X + 1 Collatz(t) number = int(in... 阅读全文
摘要:
allGuests = { 'A':{'apples':5,'pretzels':12}, 'B':{'hs':3,'apples':2} } def total(guests,item): num = 0 for k in guests: num = num +guests[k].get(item,0) return num print(... 阅读全文