Teachers
TeachNo	TeachName	CourseNo	DeptNo	StartDate	Salary
101	Kluger	101	10	20-Oct-2016	65000
102	Confucious	102	11	11-Jan-2017	73000
103	Crazer	101	10	15-Aug-2000	71000
104	Nutting	103	10	16-Aug-2007	52000
105	Brawler	104	11	20-Aug-2005	91000
106	Lazerk	107	12	20-Sep-2002	64000
107	Alienous	105	13	15-Aug-2001	79000
108	Asylant	106	13	15-Aug-2007	61000
109	fanatikal	102	11	20-Sep-2000	62000
110	Babyest	101	10	20-Aug-2003	67000

Looking for a couple SQL statements that pertain to the table above. I am using ORACLE.

1. List the teachername and courseno for courses taught by teachers whose last name start with the letter C

2. List all teachno, teacherNames, and courseno for courses they teach for teachers whose salary is above 70000.

3. How many departments do we have?