SQL Statements To Run In SQl Server
Not what you're looking for?
Write SQL queries using Between, Like and Union:
? Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. (Use salary to restrict the data.)
? Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. (Use hire dates to restrict the data.)
? Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. (Use telephone area codes to restrict data.)
? Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. (Use age to restrict data.)
? Write a SQL query that uses UNION of the two tables to produce a third table.
? Submit each query and its results paste into Word Document
Using the database included write the following queries using the SQL GROUP statement:
? Group employees by job classification: Select the employees' last names and group them by EEO-1 Classification.
? Group employees by salary: Select the employees' last names and group them by salary.
? Group employees by salary within their job classification: Select the employees' last names and group them by salary within their EEO-1 Classification.
? Select the employees' last names and group them by salary within job titles that are grouped into exempt and non-exempt.
? Finally, submit the SQL statements and the results - paste them into Word Document
write queries using the SQL SELECT statement.
**** Select all of the data from both tables before performing the following.
? Choose an EEO-1 Classification: Increase all employees' salaries that have: the selected EEO-1 classification by 10%.
? Increase all employees' salaries by 5%.
? Choose an employee from the employee table; delete this employee.
? Print out the SQL statements and the data from both tables in order to show how the data was affected. Submit these results in your text file to the Assignments Newsgroup
Using the database and tables from Week Three, write SQL statements to:
? Calculate the average salary for all employees.
? Calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees.
? Calculate the maximum salary for all employees.
? Calculate the minimum salary for exempt employees and the maximum salary for non-exempt employees.
? Calculate the minimum salary for all employees.
? Print out the SQL statements and the results.
I have included database and SQl Statements
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
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.
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.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Javscript Basics
Quiz on basics of javascript programming language.