This preview shows page 1. Sign up to view the full content.
Unformatted text preview: 6. select min(salary), max(salary), count(*) from demo.employee where department_id = '30'; 7. select grade_id, (upper_bound - lower_bound) as "Salary Range" from demo.salary_grade; 8. select customer_id, order_id, (ship_date - order_date) as "Days to Ship" from demo.sales_order order by customer_id, order_id;...
View Full Document
This note was uploaded on 04/03/2010 for the course CMPSC 121 taught by Professor Crawford,georgew during the Spring '07 term at Pennsylvania State University, University Park.
- Spring '07