Purchase Solution

Employee table

Not what you're looking for?

Ask Custom Question

I am seeking help with solving several SQL statements. I am specifically looking for the code that goes with these problems.

**First Problem**

Employee table contains the following information: state, lastname, firstname, hiredate, department, salary.
Get all employees that satisfy the following conditions:
- from the state of Kansas
- hired during the month of Mar-99
- sorted by lastname
- salary greater than 20,000

**Second Problem**

Each week a food wholesaler company fulfills orders from various customers. Normally, each customer orders the same quantity of certain items each week. Occasionally, the quantity of an item that a customer orders is significantly less than the customer's usual quantity. The information about each order is stored in a table named Invoice shown below:

CREATE TABLE Invoice (
InvoiceID int NOT NULL,
InvoiceNumber char(10) NOT NULL,
CustomerName char(30) NOT NULL,
InvoiceAmount money NOT NULL DEFAULT (0),
CONSTRAINT PK_Invoice PRIMARY KEY (InvoiceID)
)

You want to identify any pattern to these unusual orders. To do this, you need to produce a list of the invoices for each customer that is for a lesser amount than the average invoice amount for that customer.

Attachments
Purchase this Solution
Solution Summary

Employee table contains the following information: state, lastname, firstname, hiredate, department, salary.

Solution Preview

Hi,

I am attaching the same file you have attached with ...

Purchase this Solution
Free BrainMass Quizzes
C++ Operators

This quiz tests a student's knowledge about C++ operators.

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.

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: 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.

Basic Networking Questions

This quiz consists of some basic networking questions.

View More Free Quizzes
Related BrainMass Solutions

  • Write sql statement using join

    You could treat that query as a table and do an inner join with the employee table in order to translate the employee IDs into names. 6. Which employee(s) (by name) have neither a degree nor a child?

  • Relationships for any referential integrity violations.

    Answer 3 : You cannot delete the employee Chris from the employee table. Because the particular EmployeeId is referring in the Vehicle table.

  • Database help: Create an ERD, Relational Diagram, and do the tables exhibit entity integrity or referential integrity.

    Employee table has fields that required to represent an employee and can be extended to add more columns to store more information about employee.

  • Explicit SQL Statement

    Note that the 4th field in the Employee table is the employee grade field, the 2nd field in the Store table is the Store name, and the 3rd field in the Store table is the manager's ID.

  • Referential integrity in tables

    TABLE REFERENTIAL INTEGRITY EXPLANATION EMPLOYEE YES There is no JOB_CODE in Employee Table which doesn't exist in JOB Table BENEFIT YES There is no EMP_CODE or PLAN_CODE in Benefit Table which don't exist in Employee or Plan Table respectively.

  • SQL Server Database

    The primary key from the Job Title table will appear as the foreign key in the Employee table.

  • Access Database: Employee Table and a Customer Table

    Each individual should create an Access database that includes 2 different tables: an employee table and a customer table.

  • Simple Relationship Diagrams: ER diagrams

    In the Order Table (OrderTbl in the diagram), the CustNo column references the Customer table and the EmpNo column references the Employee table.

  • Relationships Related to Databases

    The table consists of employee id and co-worker employee id as its fields it's the lining table. Various types of relationships in connection to databases are described.

  • Execel Workbook

    - Field titles for the employee table should be as follows: - Employee ID number - First name - Last name - Address - Date of hire - Date of birth - Social security number - Hourly wage - Field titles for the customer table should be the following

View More Related Solutions