Workshop

The quiz questions and activities are provided for your further understanding of the current hour's topics.

Quiz

1:	Why would you need to surround a field or table name in quotes?
A1:	You would need to surround a field or table name in quotes if it contains a space, but it's good practice to always quote both field and table names.
2:	Why would you want to incorporate sorting and filtering into the SQL statement if Crystal Reports already supports those operations?
A2:	By incorporating as much of the sorting and filtering logic into the SQL statement, the report will run faster because the database is always faster on these operations.
3:	What does aliasing a field do?
A3:	Aliasing a field gives the field a virtual name that is more user friendly or appropriate for that particular query.

Activities

To ensure that you are comfortable with the topics discussed in this hour, try to perform the following tasks. Using the Xtreme Sample Database, attempt to create the following queries as SQL Commands:

• All customers whose sales are over $5000 from the USA, sorted by customer name

• All products sorted by product type name (Hint: you'll need to use both the Product and Product_Type tables)

• The total salary for employees grouped by city