| The
University of Vermont SQL Exercises 1.On your TRAIN account: Find all the tables in your Schema (Tables owned by you). Hint 1: Use user_tables Hint 2: Desc user_tables How many employees in this company? How many departments? How many employees in the accounting department? How many employees earn more than the average salary? Who is the highest paid employee in New York?
|
| Brought
to you through the courtesy of Computing
and Information Technology, University of Vermont. Copyright ©
1996 The University of Vermont and others. All rights reserved.
The University supports both institutional and personal web pages. The views expressed on personal web pages are strictly those of the author, and are not reviewed or approved by the University of Vermont Send questions and comments to Keith.Kennedy@uvm.edu Read the
Webmaster's
Policies.
|