Previous Topic: Visualizing the ReportNext Topic: Creating the Sample Query

Using CREATE in SQL Mode › Writing a Sample SQL Query › Understanding the Report

Understanding the Report

Compare the numbered items on the sample report for a description of each item you want to know about.

Report
Item

Your Query Should

REP_ID

Sort the qualifying data found by the salesperson ID and print that ID as the first column in the report.

ORD_AMT

Sort the qualifying data for each salesperson by order amount. Print the qualifying order amounts in the second column of the report.

NAME

Print the customer name for each order in the third column of the report.