Retrieve all student data about female students that live in Helsinki
Get the phone number of the teacher Susan Smith
Get all data about courses that give 3 credit units and have more than 20 lecture
hours or more than 40 hours teaching alltogether
A lecture hour costs 600 FIM and a practice hour 300 FIM,
make a report that shows the name, number and the total cost of each course
(as column PRICE) counted based on the table course
Retrieve the names of teachers (as column NAME that contains lastname space and first name)
that have no phone number
Make a report about male students that live in Espoo.
The report should contain the name columns, the birth year, and studet number.
It should be ordered primarily by the age of studets (the younger ones first) and secondarily by the name.
Make an ordered list of courses based on the amount of teaching needeed for one credit unit.
Include in your report only the name of the course and the number of needed
hours rounded to an integer as column CRCOST.
Make a list of courses that start between 15.1.2000 and 15.3.2000.
Include in your list the name, the number (as CNUMBER) and the date in
format dd.mm.yyyy as column BEGINS. Note Oracle fuction to_char gives the date properly formatted.
List the specialities of teachers. Include the first and last name of the teacher
and the name of the speciality. Order primarily by the teacher and secondarily by the speciality.
Make a report of teaching tasks of Thomas Edison on this spring (upto end of May).
Include the name of teacher, and the name of course and the tasks and their hours.
What courses suit for students that study for a certain speciality?
Which students (name and number) study both courses Network management and Object Modeling?
Which teachers both lecture and instruct paractices within the same course offering?, Give the name of the teacher and the name, number and stating time of the course.
Let us assume that expert level courses are too demanding for minor degree. Find out which student have taken to demanding courses. Give the name, number, specialily and its extent for the students and the name and phase of the course. Order the result by student.
Teachers are paid salaries according to the hours they teach. The sarary is paid in that month the job begings and in two succeeding months. For each teacher, find out the factors of his/her salary on March 2000. Give the name and number of the teacher, name of the course, its starting time in Finnish format as BDATE, type of task and hours allocated. Order the result by teacher and the time.
Find out the name and number of students that have started their studies before year 1998 but have not passed any course.