Purchase Solution

SQL Queries to Manipulate Tables

Not what you're looking for?

Ask Custom Question

Please refer to the attached file SQL1.txt that contains SQL commands to create two tables Employee and Job_Title, and populate them with data.

Write SQL queries to accomplish following.

1. Choose a Job Description and increase by 10% all employees' salaries that have the selected Job Description (not Job Title).

2. Decrease all Exempt employees' salaries from a certain State by 15%.

3. Increase all Non-Exempt employees' salaries by 5%, if employee was hired more than 3 years ago and is less than 30 years of Age.

4. Delete Exempt employees earning a Salary greater than a certain amount.

5. Calculate the maximum salary of all Exempt employees.

6. Calculate the minimum, maximum, and average salary for each Job_Description.

7. Insert 3 additional Job_Title records that no Employee holds.
Write a Select query that displays ALL Job_Descriptions and the first and last name of anyone holding that description. The query MUST show all Job_descriptions, including the 3 additional just added.

Attachments
Purchase this Solution
Solution Summary

This solution provides a detailed tutorial of the given computer science problem.

Purchase this Solution
Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

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.

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.

C# variables and classes

This quiz contains questions about C# classes and variables.

View More Free Quizzes
Related BrainMass Solutions

  • Writing SQL Queries Using a Database and Tables

    249588 Writing SQL Queries Using a Database and Tables Write SQL queries (SELECT statements) using BETWEEN, LIKE, UNION, and GROUP.

  • SQL QUERIES

    28193 SQL QUERIES I am using MS SQL SERVER 2000 (I have the database built), I would like to run these quieries. Using the database and tables write SQL queries using BETWEEN, LIKE and UNION: 1.

  • Subquery vs. Join.

    Please help me with this question: Which is better to use, a subquery or a JOIN? Why? Show an example of each to support your reasoning. Communicate with a relational database to create tables, and query and manipulate data.

  • Write SQL queries using BETWEEN, LIKE and UNION

    247061 Write SQL queries using BETWEEN, LIKE and UNION Using the database and tables from the attached file, 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

  • SQL Database

    Instructions are down below and PLEASE USE SQL SERVER 2008 Use the database and tables from last week's assignment to write SQL queries using Between, Like, and Union: - Write a SQL query that joins two tables in the example database and uses BETWEEN

  • Kudler Fine Foods- Complete Database SQL Queries

    d) Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. (Use age to restrict data.) e) Write a SQL query that uses UNION of the two tables to produce a third table.

  • SQL Statements To Run In SQl Server

    94940 SQL Statements To Run In SQl Server 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.

  • SQL Server Database for Kudler Fine Foods/Service

    · Finally, print out the SQL statements and the results. Be prepared to demonstrate your results in class. Using the database and tables from Week Three, write queries using the SQL SELECT statement.

  • Creating Tables with SQL Server

    Cheers This solution consists of a set of SQL queries to create two tables using SQL Server.

View More Related Solutions