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

/in /by
  • 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)

Attachments:

CS1100.A14.In….docxGoodReadsDB.a….accdbCS1100.A15.In….docxCS1100.A15.In….docxCS1100.Univer….accdb