File: sep11.txt Author: Jeff Kinne Contents: plan/notes for the day Note: hw3, problem 5, one way to do it is SELECT * FROM (SELECT MAX(salary) AS s, dept_name FROM instructor GROUP BY dept_name) AS t1 WHERE t1.s IN (SELECT MIN(s) as s FROM (SELECT MAX(salary) as s, dept_name FROM instructor GROUP BY dept_name) as t2) HW3 graded. A few very poor grades. Some notes... * You are supposed to start early, ask questions, and end up pretty much solving everything. Generally you will do worse on the exam than HW's, so you better do well on the HW's * You will fail if you can't do these problems... * You are supposed to ask if you are confused. Before you ask, you need to do what you are supposed to do - read the book, come to class and pay attention, etc.