Access 2000 SQL queries

已完成 已发布的 Oct 28, 2003 货到付款
已完成 货到付款

I will provide you with a Access DB and the following information must be extrated or completed via SQL. This must be done in the most simple form without any bells or whistles. Just simply provide the bare bones of what is required. The following is what is required from the DB: Using SQL, add 10 more employees to the employee table. Make sure foreign keys are correct in the Employee table. Write a SQL query that shows the number of Territories that each employeeId has. Sort by EmployeeId Write a SQL query that shows the number of orders that are for products that have a UnitPrice > $30 and the Supplier Country is USA

## Deliverables

All SQL code must be completely error free and be able to run in Access 2000. It must work explicitly according to the directions.

## Platform

Windows 98 Access 2000

PHP

项目ID: #2997800

关于项目

26个方案 远程项目 活跃的Oct 28, 2003

授予:

Quadville

See private message.

$21.25 USD 在2天内
(193条评论)
5.5

有26名威客正在参与此工作的竞标,均价$21/小时

gribfritz

See private message.

$17 USD 在2天内
(497条评论)
7.6
creativexso

See private message.

$42.5 USD 在2天内
(81条评论)
5.9
ekam

See private message.

$5.95 USD 在2天内
(111条评论)
5.7
southerndev

See private message.

$25.5 USD 在2天内
(63条评论)
5.2
sreeyavw

See private message.

$5.1 USD 在2天内
(31条评论)
5.1
stanishjohnd

See private message.

$7.65 USD 在2天内
(44条评论)
4.3
tlbell69

See private message.

$21.25 USD 在2天内
(18条评论)
4.1
rodrigouroz

See private message.

$8.5 USD 在2天内
(27条评论)
3.9
unt

See private message.

$6.8 USD 在2天内
(12条评论)
4.0
vw654347vw

See private message.

$8.5 USD 在2天内
(8条评论)
3.8
felixbaudrit

See private message.

$51 USD 在2天内
(8条评论)
3.2
vnicky

See private message.

$11.05 USD 在2天内
(15条评论)
2.8
stolevw

See private message.

$12.75 USD 在2天内
(28条评论)
2.6
billwooten

See private message.

$42.5 USD 在2天内
(1条评论)
0.7
dannicvw

See private message.

$8.5 USD 在2天内
(2条评论)
0.7
brandoncooksey

See private message.

$6.8 USD 在2天内
(3条评论)
0.2
npond

See private message.

$4.25 USD 在2天内
(4条评论)
0.0
viraln25sl

See private message.

$42.5 USD 在2天内
(0条评论)
0.0
arpcp

See private message.

$17 USD 在2天内
(0条评论)
0.0
vvrk

See private message.

$25.5 USD 在2天内
(0条评论)
0.0