ClassAssignmentUniversitySolution.pdf - Name: PWSP DATABASE...

PWSP DATABASE MANAGEMENENT CLASS
SQL ASSIGNMENT SOLUTIONS
FEBRUARY 26-27, 2007
INSTRUCTOR: SANJAY GOEL
Name: ID:
Using the University Records Database solve the following problems.
1. Retrieve the name, city, and grade point average (GPA) of students with a high (GPA) greater than or equal
to 3.7). The results follow the SELECT statement.
Select StdFirstName, StdLastName, StdCity, StdGPA
From Student
Where StdGPA >= 3.7;
2. List all columns and rows of the Faculty table. The resulting table is show in two parts.
Select *
From Faculty;
3. List the name, city, and increased salary of faculty hired after 1991 if the salary raise is 10%.
Note: The year function extracts the year part of a column with a date data type.
4. List the senior level IS courses. 5. List the name and hiring date of faculty hired in 1994 or 1995.