Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create the following statements against the AdventureWorks 2 0 1 9 database in the eLumin environment. Your answers should be submitted as one file with
Create the following statements against the AdventureWorks database in the eLumin environment. Your answers should be submitted as one file with the number of records affected by each statement.
A Delete statement to remove all records from the Person.Person table where the LastName starts with ja and they have a phone number in the area code.
An Insert statement to add more records to the Sales.Customer table.
An Update statement to change the SafeytStockLevel to for records in the Production.Product table that have a size and
An Update statement to change the birth year to the SickLeaveHours to for all records in the HumanResources.Employee tables where the Job Title contains Manager and the MaritalStatus is M
Upload a file to Canvas containing scripts for all the above, be sure the filename contains your full name and has a sql extension.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started