[SOLVED] Dbs211 lab 03 – sql – single table queries

ObjectivesThe purpose of this lab is to start learning SQL by writing basic DML statements involving a single table.  You will learn to create basic CRUD statements (queries as well as insert, update and delete). Submission:Your submission will be a single Word document with the question#, SQL query, solutions if it is a text or a screen shot provided. (with a .docx file extension). Create a comment header that includes your name, student id, the date and the purpose of the file (i.e. DBS211 – Lab 03_firstname). SetupCreate a new worksheet in SQL developer and add an appropriate comment header that includes your name, student id, the date and the purpose of the file (i.e. DBS211 – Lab 03).   After every command and result in each question paste them in your Word fileImmediately under the comment header, enter the following line and then execute it:SET AUTOCOMMIT ON; Style GuideYour SQL should be written using the standard coding style:Using comments to number the question answers, write the SQL code to complete the following tasks. Tasks: