Course Hero Logo

ClassAssignmentUniversitySolution.pdf - Name: PWSP DATABASE...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 2 out of 4 pages.

PWSP DATABASE MANAGEMENENT CLASSSQL ASSIGNMENT SOLUTIONSFEBRUARY 26-27, 2007INSTRUCTOR: SANJAY GOELName: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 equalto 3.7). The results follow the SELECT statement.Select StdFirstName, StdLastName, StdCity, StdGPAFrom StudentWhere StdGPA >= 3.7;2.List all columns and rows of theFacultytable. 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:Theyearfunction 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.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 4 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
Ravi Narayan
Tags
Gymnasium, ECTS grading scale, Academic transfer

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture