for this assignment you will display and modify information from a microsoft access database by using sql commands

For this assignment, you will display and modify information from a Microsoft Access database by using SQL commands.

Using the Microsoft Access database Books, write SQL statements for the following tasks.

  • Write an SQL statement to display the publication ID, publication date, cost, and category of each book planned for publication ID number 4.
  • Repeat the previous task but include ID and Date as column aliases for the first two columns.
  • Write an SQL statement to display the least expensive retail price book in each book category.
  • Repeat the previous task but sort the displayed categories in the descending order.
  • Write an SQL statement to display the customer number, city of destination, and shipping date for all shipments with order number above 2. (Hint: Use the Orders table.)
  • Repeat the previous task but further restrict the output to shipping dates after January 1, 2013. (Hint: The date restriction will require a format identical to the one displayed in the previous task, and it must be surrounded by pound signs—#01/01/2013# for example.)
  • Write an SQL statement to display the publication ID, average retail price, and average cost of all books. Group the output by publication ID.
  • Write INSERT statements to add the following data to the Publisher table:
PubID Name Contact Phone
6 READ WITH US John Doe 866-888-9999
7 KNOWLEDGE FOR ALL Jane Doe 800-1212-5555
8 CHEAP PUBLISHING Tom Smith 000-321-4071
9 TEXT AND MORE John Carter 032-100-7777
10 BOOK BUSTER George Stevens 777-555-1212

  • Write a single SELECT statement that will verify the records inserted.
  • Write a DELETE statement to remove only the new BOOK BUSTER record.
Looking for a solution written from scratch with No plagiarism and No AI?

WHY CHOOSE US?

We deliver quality original papers

 Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected  

Free revisions

 We offer our clients multiple free revisions just to ensure you get what you want.

Discounted prices

 All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount

100% originality

 We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI

On-time delivery

 We will deliver your paper on time even on short notice or  short deadline, overnight essay or even an urgent essay
 
/by