The Dataweekender conference is coming up again this Saturday Oct 17! After the very successful first Dataweekender conference on May 2nd 2020 with more than 1000 sign-ups and with an excellent speaker lineup, the 6 founders of Dataweekender decided to setup another one this year. Just like the first time, I will be moderating again this October 17. The conference will be held from 9:00 - 19:00 Central European Summer Time....
Why window functions may come in handy Let us dive directly into a real world example. You’ve got a table with salaries of different job functions and you are asked to find out what the n-tiles (quantiles, mean etc.) are of each function within a company. So this means you’ve got many people that hold a position which you want to compare with others. You want to compare salaries of marketing professionals to their peers, but you don’t want to compare said salaries to marketing directors because they have their own salary bands....
This is my first post, testing syntax highlighting here: write-output "Hello World" SELECT * FROM TABLE WHERE A = B print("Hello World!")