Solution-Make a note of how many records that were deleted

Make a note of how many records that were deleted

Assignment Help Programming Languages

Reference no: EM13929834

a. You have been asked to write a SQL statement that will delete ConsumerID 45678.

b. Save your SQL query as SQLQuery1D1 and execute the statement.

DELETE FROM CustomerData WHERE ConsumerID = 45678;

c. Create a SQL statement that will delete all records that are from the state of California or Texas.

d. Save your SQL query as SQLQuery1D2 and execute the statement.

e. Make a note of how many records that were deleted.

f. Write 1 SQL query that will prove that no records exist for ConsumerID 45678 or the Consumer is from California or Texas.

g. Save your SQL query as SQLQuery1D3 and execute the statement.

h. Take a screen shot of your query results.

Reference no: EM13929834

Questions Cloud

Write an informal presentation to educate nurses : Write an informal presentation to educate nurses about how the practice of nursing is expected to grow and change.

Allocate joint cost method using the physical-units method : Hernandez Chemical Company's production process for two of its solvents can be diagrammed using a process map as shown in Exhibit 12-25. Allocate the $400,000 joint cost to solvents A and B by the physical-units method

The machine has an estimated residual value : Big Sky Mining Company must install 1.5 million of new machinery it its Nevada mine. It can obtain a bank loan for 100% of the purchase price, or it can lease the machinery. Assume that the following facts apply: (1)The machinery falls into the MACRS..

How hp plans for capital budgeting and risk assessment : Explain HP reporting and disclosure of its sustainability measures, including any metrics used and audits performed.

Make a note of how many records that were deleted : Save your SQL query as SQLQuery1D3 and execute the statement.

Problem regarding the employee commitment : We conduct research about The Association of Employee Commitment, Organizational Support, Job Satisfaction on Intention to Leave of nurses in Najran, Saudi Arabia I want from you only introduction and literature review for my research the instrume..

What is the pretax cost of debt : Jiminy’s Cricket Farm issued a bond with 25 years to maturity and a semiannual coupon rate of 12 percent 3 years ago. The bond currently sells for 94 percent of its face value. The company’s tax rate is 35 percent. What is the pretax cost of debt? Wh..

Compare and contrast technique use for job analysis : Compare and contrast the major technique that organizations use for job analysis? Specify the circumstances under which, from a firms perspective, a firm''s HR might be seen as a organizational strength and specify organizational weakness aswell?

Using the arithmetic average growth rate in dividends : Suppose Stark Ltd. just issued a dividend of $2.24 per share on its common stock. The company paid dividends of $1.80, $1.98, $2.05, and $2.16 per share in the last four years. If the stock currently sells for $45, what is your best estimate of the c..

User Account

All Pages

Make a note of how many records that were deleted

Reference no: EM13929834

Reference no: EM13929834

Questions Cloud

Reviews

Write a Review

Programming Languages Questions & Answers

Write a haskell program to calculates a balanced partition

Create an application to run in the amazon ec2 service

Explain the process to develop a web page locally

Write functions

Programming assignment

Write a prolog program using swi proglog

Create a custom application using eclipse

Create a application using the mvc architecture

Develops bespoke solutions for the rubber industry

Design a program that models the worms behavior

Writing a class

Design a program that assigns seats on an airplane

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT