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.
SQL Assignment 2 This assignment has multiple parts, but you will only be required to submit screenshots after each spec
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
SQL Assignment 2 This assignment has multiple parts, but you will only be required to submit screenshots after each spec
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!