Microsoft SQL STATEMENTS
Not what you're looking for?
I am using Microsoft SQL Server 2000
1. Database Tables
TABLE: Employees
Job_title_code
Social_security_number
Last_name
First_name
Address
City
State
Zip_code
Telephone_area_code
Telephone_number
Email_address
Hire_date
Salary
TABLE: Job_title
Job_title_code
Job_title
Exempt_non_exempt_status
Minimum_salary
Maximum_salary
2. Queries using the SQL GROUP statement:
A. Group employees by salary within their job code: Select the employee's last name and group them by salary within their job_title_code.
B. Select the employee's last name and group them by salary within job titles that are grouped into exempt and non-exempt.
Purchase this Solution
Solution Summary
Microsoft SQL STATEMENTS are included.
Solution Preview
Select Last_name, Salary,job_title_code from Employees
group by ...
Purchase this Solution
Free BrainMass Quizzes
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Javscript Basics
Quiz on basics of javascript programming language.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.