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 "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

{[ snackBarMessage ]}

Ask a homework question - tutors are online