SQL Exercise

Problem

• Write SQL statement to create an authors table. See image.
• Write SQL statement to add primary key to the authors table ( you select the primary key)
• Write SQL Statements to insert the following data into the authors table: See image.

Problem

• Write SQL statement to create an publisher table See image.
• Write SQL statement to add primary key to the publisher table ( you select the primary key)
• Write SQL Statements to insert the following data into the publisher table See image.

Problem

• Write SQL statement to create an Book table See image.
• Write SQL statement to add primary key to the Book table ( you select the primary key)
• Write SQL statement to add Foreign key to the Book table
• Write SQL Statements to insert the following data into the Book table See image.
• Write SQL statement to search for publishers that are located only in the USA and New York City
• Write SQL statement to update the following records: Change the price from the book " He is Gone" from 7.99 to 12.99
• Write SQL statement to double the price of all mystery books.