Encerrado

SQL HW Help with Access

Hi there, I need to have the following problems on SQL scripts, Attached you will find the Access file. Please read carefully. Thanks Description: Answer the eight problems below by writing the appropriate SQL statements. This database. Using this database, write the SQL statements requested below, and please save and name these SQL statements as numbered below (e.g., query1, query2, etc.). 1. Delete the row in the Quotation table where the quoted price is $50. 2. Update the quote date for some of the quotes from supplier number 71. If the quote date is < 6/1/2000, then set the new quote date to 3/11/2002. 3. Using the IN clause, show all of the fields in the Quotation table for quotes from suppliers 64, 71, and 72. You must use a 'symbol' in your SQL statement that will show ALL of the fields in the table. 4. List the part number, part name, quantity on hand, quantity on order, and quantity on hand plus quantity on order, for all parts where the quantity on hand is less than or equal to 7. Give the column for "quantity on hand plus the quantity on order" the label "Future Total". 5. Provide a count of the number of products quoted by supplier number 70. 6. List the supplier number, supplier name, and quoted price for all suppliers who supply bolts. 7. List the supplier name, part name, and quoted price in descending order by price for part number 320. 8. List the part number, part name, average quoted price, minimum quoted price, and maximum quoted price for all parts having a minimum quoted price that is greater than $4.00. You must use the Having clause. Tip: Look at the data in the mdb file and visually determine in advance what data should appear in the result for each query. Then compare this with the recordset obtained when you run your query.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

SQL 2000, Access

Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: writing result table, work made hire clause, work hire clause, package sql, statement problems, sql server price list, sql price, sql coder hire, row 44, parts database access, hire clause, new hire quotes, need sql help, look appropriate program web, need hire sql, access parts database, sql less, php less equal, on sql, less symbol, sql server scripts, need column writing, hw, hire sql, data source sql

Acerca do Empregador:
( 49 comentários ) United States

ID do Projeto: #3051821

77 freelancers estão ofertando em média $18 para este trabalho

javaoraclepro

See private message.

$68 USD in 2 dias
(164 Comentários)
7.5
atanughosh76

See private message.

$21.25 USD in 2 dias
(125 Comentários)
7.5
GetReal

See private message.

$4.25 USD in 2 dias
(300 Comentários)
7.2
pShankar2

See private message.

$29.75 USD in 2 dias
(398 Comentários)
7.0
TakeRealUK

See private message.

$17 USD in 2 dias
(782 Comentários)
7.0
DataMouse

See private message.

$21.25 USD in 2 dias
(166 Comentários)
6.6
hasnut

See private message.

$55.25 USD in 2 dias
(144 Comentários)
6.3
kmoniqa

See private message.

$17 USD in 2 dias
(130 Comentários)
6.2
simplesimonvw

See private message.

$34 USD in 2 dias
(50 Comentários)
5.9
imarzouka

See private message.

$8.5 USD in 2 dias
(83 Comentários)
5.9
michaeldstephens

See private message.

$25.5 USD in 2 dias
(95 Comentários)
5.7
premrishi

See private message.

$48.45 USD in 2 dias
(61 Comentários)
5.7
appdevservice

See private message.

$8.5 USD in 2 dias
(87 Comentários)
5.6
jaywangvw

See private message.

$21.25 USD in 2 dias
(79 Comentários)
5.6
irenagroup

See private message.

$21.25 USD in 2 dias
(99 Comentários)
5.5
ddumitrascu

See private message.

$29.75 USD in 2 dias
(116 Comentários)
5.5
mickey1vw

See private message.

$8.5 USD in 2 dias
(143 Comentários)
5.5
kgivw

See private message.

$12.75 USD in 2 dias
(71 Comentários)
5.6
qcz

See private message.

$11.05 USD in 2 dias
(20 Comentários)
5.2
ashruvw

See private message.

$9.35 USD in 2 dias
(64 Comentários)
5.0