Selecting appropriate query types, including: when static and dynamic parameters should be used, when simple, complex, nested and summary queries (including cross-tab queries/pivot tables) should be used