LAB 4 - 6. select min(salary), max(salary), count(*) from...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Keary Hoffman LAB 4 1. select product_id from demo.price where end_date is NULL; 2. select customer_id, name, city from demo.customer where state = 'CA' and salesperson_id = 7844; 3. select customer_id, order_id, total from demo.sales_order where customer_id >= 200 and customer_id <= 205 order by total desc; 4. select name from demo.customer where name like '% AND %'; 5. select sum(total) from demo.item where order_id = 503;
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

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 &quot;Salary Range&quot; from demo.salary_grade; 8. select customer_id, order_id, (ship_date - order_date) as &quot;Days to Ship&quot; 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.

Ask a homework question - tutors are online