This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: order by is followed by the keyword desc. You can sort the query results by more than 1 column. Let’s list students sorted by grade and instructor id. Display how many rows are in the dbst651_students table. You can define the column alias names. Notice that count(*) heading is replaced with STUDENTCOUNT heading. Think about: 1. What if I want to select data from more than one table? How would I list student names and the corresponding instructor names in the same report? 2. What if I want to display how many students got each letter grade? 3. Is it possible to specify more than one criterion in the where clause? What if I want to list students who have an A and take a class taught by Yelena? These topics will be covered later in the course....
View Full Document
- Spring '09
- Yelena - TA
- Personal name, Chinese name, List student data, dbst651_students table