Explore BrainMass
Share

Employee table

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com March 21, 2019, 11:21 am ad1c9bdddf
https://brainmass.com/computer-science/sql/employee-table-40978

Attachments

Solution Preview

Hi,

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

Solution Summary

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

$2.19