MS SQL TASK:
Create new MS SQL database. In this database, create a table called “library” with the following information:
Andrew Jacobson (2003 April 27) “Blue Gift”. Publisher: CRC Press
Bill Kauffmann (2005 March 6) “Willow in the Mist”. Publisher: Delirium Books
Bill Kern (2005 March 1) “Time of Silence”. Publisher: Del Sol Press
Catherine Wilde (2008 June 30) “Black Tears”. Publisher: CRC Press
John Becker (2008 May 2) “Splintered History”. Publisher: ABC Publishing
John Becker (2006 July 17) “Lost Ashes”. Publisher: Delirium Books
John Becker (2010 January 15) “Forgotten Girl”. Publisher: ABC Publishing
Michael Ernst (1954 December 4) “Tower in the Flame”. Publisher: Beyer Books
Natalie Haast (1988 February 25) “Frozen Legacy”. Publisher: Beyer Books
Samantha Steele (1999 October 8) “Doors of Danger”. Publisher: ABC Publishing
Samantha Steele (1993 February 11) “Diamond Petals”. Publisher: Beyer Books
Execute the following SQL queries and provide the results of their execution in form of screenshots: Continue reading →