Closed

SQL

This project was awarded to duggan for $2 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $5000 USD
Total Bids
25
Project Description

Using SQL statements, complete the following tasks: Note that this should be applied to the MS access database provided. 1/display all customers names and the amount of debit owed by each. 2/Display those items ona given catalogue page whose number in stock is greater than a given value. 3/Display all customers and how much credit each has remaining where credit limit is greater than $1000. 4/Display all customers with a credit limit within a given range of values. 5/Produce an alphbetical list of customers where postcode contain NE. 6/Produce an ascending alphabetic list of customers within a descending aphabetical lists of towns in which they live. 7/Output number of customers and total of ALL their debit. 8/List all customers with assistant id 1 with credit over $50. 9/List in order the total order value of each order (USING GROUP BY). 10/ List in order total value of orders over $20 (USING HAVING). 11/List number of each item ordered, unit price and description. 12/list customers represented by assitant ID 2. 13/ list customers represented by assistant ID 3 that have orders on file. 14/List customers represented by assistant ID4 that dont have any orders.

## Deliverables

Word document of the SQL statements used and the results of each query for all of the above 14 tasks. Coders can be as ad lib as they require with the sample data i have provided on the database. Where i have not stated what data must be used you can choose your own from the database. If you need a password to view database in access use login as: admin password: 4321


## Platform

please only word documents preferably 2002.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online