Островок

ML modellari uchun A/B sinovlarida qanday muammolar bor (o'qitish ma'lumotlari fikr-mulohazasi sikli)?

Vazifa #2 Har bir bo‘limda eng yuqori maosh oladigan TOP-3 xodimlarni ko‘rsatuvchi so‘rov yozing. Bo‘lim nomi, xodim nomi va uning maoshini ko‘rsating. employee jadvali: | id | name | salary | dept_id | |----|-------|--------|---------| | 10 | John | 1000 | 2 | | 20 | Tom | 5000 | 3 | | 30 | Bill | 3000 | 2 | department jadvali: | id | name | |----|-----------| | 1 | Marketing | | 2 | IT | | 3 | Finance | Natija: department_name, num, employee_name, salary cte sifatida: select d.name as department_name, e.name as employee_name, e.salary, dense_rank from employee e join department d on e.id = d.id

Ushbu lavozim uchun muhim deb hisoblagan professional tajribangiz va ko'nikmalaringiz bilan bo'lishing.

Вывод слов для чисел, делящихся на 2, 3 и 6

Loyihada siyosiy moslashuv nima?