ITM 500 Lecture 3: ITM500-Week 3
Document Summary
Details for all courses that have the characters business anywhere in course description. Details for all courses that"s description starts with the characters business . Details for faculty hired before feb 1st 1998. Where courseno like ___3%" the underscore is positional (3 underscores. Faculty where fachiredate < 1998/02/01" or feb 1 1998". Details for faculty hired in april 1998. Where fachiredate >= 1998/04/01" and fachiredate <= 1998/04/30". Or where year(fachiredate) = 1998 and month(fachiredate) = 4. Details for faculty whose salary if increase by 10% would exceed ,000. As about but also displayed is the new calculated salary with a column alias. Facsalary *1. 1 as new salary from faculty where facsalary * 1. 1 >70000. Count the total number of students (row entries in the student table) counting rows. Select count(*) as number of students from student. Shows just a new chart with number of students as header and a number under it.