Purchase Solution

Write SQL SELECT, UPDATE, and DELETE statements

Not what you're looking for?

Ask Custom Question

Write SQL SELECT, UPDATE, and DELETE statements.
Using the database and tables from Week Three, write queries using the SQL SELECT statement.
Note: Select all of the data from both of your tables before you perform 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.
Save the SQL statements and the data from both tables in order to show how the data was affected.

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.

In Microsoft SQL Server Management Studio, save your SQL statements as .SQL files. Save your SQL output as .RPT files. You will need to turn in both types of files (.SQL and .RPT)

Attachments
Purchase this Solution
Solution Summary

The expert writes SQL SELECT, UPDATE, and DELETE statements.

Purchase this Solution
Free BrainMass Quizzes
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.

Javscript Basics

Quiz on basics of javascript programming language.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

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.

Basic Networking Questions

This quiz consists of some basic networking questions.

View More Free Quizzes
Related BrainMass Solutions

  • Database Systems SQL Statement Examples

    Strategic Planning for Database Systems SQL Statements Write 2 SQL statements a piece (SELECT INSERT, UPDATE, and DELETE) based upon database tables of your choice (i.e. customers, orders, vendors etc).

  • SQL statements and query

    212168 SQL statements and query (3.7) Write a SQL query that uses UNION of the two tables. Be creative.

  • Demonstration of several different queries

    151561 Create SQL Statements using Current SQL Database Using the database and tables from Week Three, write queries to the specifications listed below.

  • MS SERVER SQL SCRIPT PROBLEMS/MS SQL SERVER 2003

    29936 MS SERVER SQL SCRIPT PROBLEMS/MS SQL SERVER 2003 Using the database and tables from attached document, write queries using the SQL SELECT statement.

  • Write SQL Statements

    three SQL statements: the first statement should add the pending amounts to the appropriate accounts, the second statement should subtract the pending amounts from the appropriate accounts, and the third statement should delete the pending balance transfer

  • SQL Operator Definitions

    Compose a short definition and provide one example for each of the following SQL operators: SELECT, INSERT INTO, UPDATE, and DELETE. (700 WORDS). The select statement is used to 'select' or choose data from a database.

  • MS SQL STATEMENTS

    29123 MS SQL STATEMENTS I am using Microsoft SQL Server 2000 1.

  • Structured Query Language (SQL) Preliminaries

    Name and describe the SQL statements used for data modification. INSERT, DELETE, and UPDATE commands, which are used to add, remove, and change data values respectively. 3. Compare the join and the SQL subquery.

  • write the code that implements the matrix using three roles: CHIEF_EDITOR, WRITERS, and EDITORS

    ,CUSTOMER to WRITERS; grant update on WANT_AD , CLASSIFIED_AD , CLASSIFIED_SECTION , CUSTOMER to WRITERS; grant delete on WANT_AD , CLASSIFIED_AD , CLASSIFIED_SECTION , CUSTOMER to WRITERS; create role CHIEF_EDITOR; grant select on

View More Related Solutions