SQL Assignment 2 This assignment has multiple parts, but you will only be required to submit screenshots after each spec
Posted: Thu Jul 14, 2022 2:28 pm
SQL Assignment 2
This assignment has multiple parts, but you will only berequired to submit screenshots after each specificquery.
PART 1: Create a Table and Insertdata
EXPECTED OUTPUT:
Klassen|Karen|5555555555|UT|56
Doe|John|1234567890|TX|43
Smith|Jane|12378904567|GA|22
Besure to take a screenshot of this query and code before movingon.
PART 2: Update data
Note: for this exercise you will need to leave all theper-formatted code and enter your queries in place of the "--entercode here" text.
EXPECTED OUTPUT
Be sure to take a screenshot of this query and codebefore moving on.
PART 3: Deleting data
Note: You do not need to use the names below!
EXPECTED OUTPUT:
John|Doe|43
Eric|Smith|26
Karen|Klassen|56
Ben|Zhao|34
Besure to take a screenshot of this query and code before movingon.
This assignment has multiple parts, but you will only berequired to submit screenshots after each specificquery.
PART 1: Create a Table and Insertdata
EXPECTED OUTPUT:
Klassen|Karen|5555555555|UT|56
Doe|John|1234567890|TX|43
Smith|Jane|12378904567|GA|22
Besure to take a screenshot of this query and code before movingon.
PART 2: Update data
Note: for this exercise you will need to leave all theper-formatted code and enter your queries in place of the "--entercode here" text.
EXPECTED OUTPUT
Be sure to take a screenshot of this query and codebefore moving on.
PART 3: Deleting data
Note: You do not need to use the names below!
EXPECTED OUTPUT:
John|Doe|43
Eric|Smith|26
Karen|Klassen|56
Ben|Zhao|34
Besure to take a screenshot of this query and code before movingon.