added window-function and two views with queries (exercises 3.2, 4.1, 4.2)