Courses/Computer Science/CPSC 203/CPSC 203 Template/Labs Template/Week 2 - Lab 2: Crosstab queries, Custom Calculations (If .. Then use example databses already created)--remove this part.

One: Give Me Crosstabs
This query retrieves some specific information as well as uses a field to perform a calculation. For example, this query will obtain all book publishers and performs an average calculation to determine what each book publisher's average is for giving an advance to book authors. PATTERN: SELECT TableNamei.FieldNamej, StatFunction(TableNamep.FieldNameq) As StatFieldnameq …. FROM TableNamei, Tablenamep … WHERE( TableNamei.Pkey = TableNamep.Fkey) …. GROUPBY TableNamei.FieldNamej

EXAMPLE: INCLUDE SCREENSHOT