In Progress

SQL

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.

Skills: Engineering, Microsoft Access, MySQL, PHP, Software Architecture, Software Testing

See more: sql price, range query, i need an assitant, i need an admin assistant, 1000 word document, what is ms sql, ms access sql, ona, list ascending, catalogue word, word catalogue, order query platform, catalogue price list, produce sql access, word query sql, value engineering, preferably engineering, word sql database, access sql query, sql query access, word database sql, access sample orders customers, word document database access, order using access, catalogue order

About the Employer:
( 21 reviews ) United Kingdom

Project ID: #2899281

Awarded to:

duggan

See private message.

$2 USD in 14 days
(4 Reviews)
3.3

25 freelancers are bidding on average $34 for this job

oleg21

See private message.

$34 USD in 14 days
(137 Reviews)
7.0
Prashantskin

See private message.

$25.5 USD in 14 days
(510 Reviews)
7.0
hernest

See private message.

$59.5 USD in 14 days
(122 Reviews)
6.8
wi3girlsvw

See private message.

$25.5 USD in 14 days
(231 Reviews)
6.5
dreamzenith

See private message.

$17 USD in 14 days
(9 Reviews)
6.1
sanatanvw

See private message.

$42.5 USD in 14 days
(72 Reviews)
5.5
s1301950

See private message.

$25.5 USD in 14 days
(35 Reviews)
5.3
ingeniadesign

See private message.

$25.5 USD in 14 days
(53 Reviews)
5.1
Uplink03

See private message.

$23.8 USD in 14 days
(66 Reviews)
4.7
compsyseng

See private message.

$11.9 USD in 14 days
(26 Reviews)
4.0
kaspvw

See private message.

$21.25 USD in 14 days
(25 Reviews)
4.0
pvavw

See private message.

$38.25 USD in 14 days
(39 Reviews)
3.9
bemasvw

See private message.

$8.5 USD in 14 days
(45 Reviews)
3.7
webffiliates

See private message.

$21.25 USD in 14 days
(19 Reviews)
3.7
techjunc

See private message.

$21.25 USD in 14 days
(21 Reviews)
3.6
georgvw

See private message.

$17 USD in 14 days
(19 Reviews)
3.4
stmpeters

See private message.

$12.75 USD in 14 days
(21 Reviews)
2.7
kevinmvw

See private message.

$17 USD in 14 days
(0 Reviews)
0.0
austin94

See private message.

$38.25 USD in 14 days
(0 Reviews)
0.0
codecruiservw

See private message.

$195.5 USD in 14 days
(0 Reviews)
0.0