Question
Write the following SQL statements in Microsoft Access by using the Books database. Once complete, copy and paste the SQL statements in a Microsoft Word document:
Write SQL statements:
ISBN Title Author PubDate Cost Retail Category PubID 1234567890 A Good Book John Jeffries 10/11/2005 13.5 15.00 Non-Fiction 7 2314569874 Trains for Everyone Cory Berkey 12/15/2011 10.25 25.25 Children 8 1598745682 Eating In Susan Smythe 09/09/2012 20.00 30.50 Cooking 6 99954123654 Another Vampire Story Ann Oats 09/05/2010 11.23 13.52 Fiction 4 1025874159 Databases are Fun! Tony Stevens 01/01/2013 4.12 5.23 Information Systems 9
Explanation / Answer