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.
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).
SQL 2000, Access