Building Queries Using Multiple Tables Using Wase Widening Aggregation Selection Eli 2384725

  • Building queries using multiple tables using WASE (Widening-Aggregation-Selection-Elimination of duplicates) also called WAFE (Widening-Aggregation-Filtering-Elimination of duplicates)
  • Use GROUP BY to eliminate duplicates
  • Apply aggregation functions to groups as well as tables
  • Create calculated fields (Widening)
  • Leverage nested queries to build complex queries
  • Follow the Principle of Simplest Query (WAFE)