Update the second customer’s email address with this new email address: you@dzi.com， CREATE TABLE CUSTOMER ( CustomerID NUMBER(10) PRIMARY KEY, FirstName VARCHAR2(50), LastName VARCHAR2(50), Email VARCHAR2(100), PhoneNumber VARCHAR2(20) );

To update the second customer's email address with the new email address "you@dzi.com", you can use the following SQL query:

UPDATE CUSTOMER
SET Email = 'you@dzi.com'
WHERE CustomerID = 2;

This assumes that the second customer has a CustomerID of 2 in the CUSTOMER table. If the ID is different, you will need to adjust the query accordingly.

Also, this assumes that the table already exists. If not, you can use the following SQL query to create the CUSTOMER table with the specified columns:

CREATE TABLE CUSTOMER (
  CustomerID NUMBER(10) PRIMARY KEY,
  FirstName VARCHAR2(50),
  LastName VARCHAR2(50),
  Email VARCHAR2(100),
  PhoneNumber VARCHAR2(20)
);

This creates a table named CUSTOMER with columns for CustomerID, FirstName, LastName, Email, and PhoneNumber. The CustomerID column is specified as the primary key.