PS Query & SQL

Using the tools you have on-hand, you may enhance your queries and expand the functionality using expressions and subqueries. Learn how to exclude a group where more than one value may be possible (such as student groups, service indicators), select a first or last term and related data, list multiple values of a field in one field (listagg-thanks Troy!), calculate a term GPA as it was before repeats were calculated, etc., using subqueries and expressions!