ขนาดวิดีโอ: 1280 X 720853 X 480640 X 360
แสดงแผงควบคุมโปรแกรมเล่น
เล่นอัตโนมัติ
เล่นใหม่
talented youngsters, good questions & good answers, learnt a lot, thank you very much :)
Thank you 😊
select id,dept,salary,avg(Salary) over(partition by dept) as avg_sal,dense_rank() over(partition by dept order by salary desc) as rnfrom emp100
for ele in s.split(' '): if ele in d: d[ele]+=1 else: d[ele]=1for key,val in {i : d[i] for i in sorted(d,key=d.get,reverse=True)}.items(): print(f'{key}|{val}')
job --> stages --> tasks , dag scheduler, task scheduler missing in explanation
S = """Data engineering is a good skill Data is a new Oil Data Enginering skill is massive""" words = S.split()dict1 = {}for i in words: dict1[i] = words.count(i)print(dict1)
talented youngsters, good questions & good answers, learnt a lot, thank you very much :)
Thank you 😊
select id,dept,salary,
avg(Salary) over(partition by dept) as avg_sal,
dense_rank() over(partition by dept order by salary desc) as rn
from emp100
for ele in s.split(' '):
if ele in d:
d[ele]+=1
else:
d[ele]=1
for key,val in {i : d[i] for i in sorted(d,key=d.get,reverse=True)}.items():
print(f'{key}|{val}')
job --> stages --> tasks , dag scheduler, task scheduler missing in explanation
S = """Data engineering is a good skill
Data is a new Oil
Data Enginering skill is massive"""
words = S.split()
dict1 = {}
for i in words:
dict1[i] = words.count(i)
print(dict1)