SELECT u.id
FROM comments c
LEFT JOIN users AS u ON u.id = c.user_id
WHERE c.created_at > to_timestamp('01.01.2019', 'DD.MM.YYYY')
AND c.created_at < to_timestamp('01.02.2019', 'DD.MM.YYYY')
GROUP BY u.idmysqlCREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON database_name.* TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
button.onclick = my_function;
D = [1,2,3,4,5,6,7,8,9,10]
print(sum(D[::4])+sum(D[1::4]))
#так тоже можно
print(sum(D[::4]+D[1::4]))
R = D[::4]+D[1::4]
print(R)#[1, 5, 9, 2, 6, 10]
R.sort()#чтобы были по порядку
print(R)
print(sum(R))import json
try:
data = json.load(open("file.json","r"))
except:#кавычки должны быть двойные
with open("file.json","r") as f:
data = json.loads(f.read().replace("'","\""))
for k,v in data.items():
if k=="damage":
summa = 0
for k1,v1 in v.items():
summa+=v1
#############И так далее
#или
summa =sum(data["damage"].values())>>> data = eval("""{'camps_stacked': 0,
'creeps_stacked': 0,
'damage': {'npc_dota_badguys_siege': 291,
'npc_dota_badguys_tower1_mid': 46,
'npc_dota_creep_badguys_melee': 3599,
'npc_dota_creep_badguys_ranged': 1677,
'npc_dota_hero_bounty_hunter': 1709,
'npc_dota_hero_dragon_knight': 2809,
'npc_dota_hero_ember_spirit': 1463,
'npc_dota_hero_phoenix': 3557,
'npc_dota_hero_troll_warlord': 1678,
'npc_dota_observer_wards': 8},}""")
>>> sum(data["damage"].values())
16837
>>>apt search PySide2