1.	SELECT CNO, CNAME FROM COURSES
	WHERE STUDYEAR = 1
	ORDER BY CNAME

2.	SELECT COUNT(*) FROM STUDENTS
	WHERE SNAME LIKE 'A%'

3.	SELECT CITY, COUNT(*) AS "STUDENTS FROM CITY" FROM STUDENTS
	GROUP BY CITY

4.	SELECT TEACHERS.TNO, TITLE, TNAME, COURSES.CNO, COURSES.CNAME FROM TEACHERS
	JOIN TSC ON TSC.TNO = TEACHERS.TNO
	JOIN COURSES ON TSC.CNO = COURSES.CNO
	--GROUP BY TEACHERS.TNO

5.	SELECT TEACHERS.TNO FROM TEACHERS
	JOIN TSC ON TSC.TNO = TEACHERS.TNO
	JOIN COURSES ON TSC.CNO = COURSES.CNO
	WHERE COURSES.STUDYEAR != 1
	GROUP BY TEACHERS.TNO

6.	SELECT STUDYEAR, COUNT(CNO) FROM COURSES
	GROUP BY STUDYEAR

7.

8.

9.

10.

11.

12.

13.	SELECT TNO, TITLE, TNAME FROM TEACHERS
	WHERE SUPNO IS NULL

14.	SELECT TNO, TNAME FROM TEACHERS
	--JOIN TSC TSC.TNO = TEACHERS.TNO

15.

16.

17. SELECT COUNT(*)	FROM STUDENTS

18.	CREATE VIEW [EXAMPLE] FROM TSC
	JOIN

19.

20.

21.

22.

23.

24.

25.