CREATE DATABASE ZChallengeDB;
GO

USE ZChallengeDB;
GO

CREATE TABLE customers (
    id INT PRIMARY KEY IDENTITY(1,1),
    name VARCHAR(50)
);
GO

INSERT INTO customers (name) VALUES ('AlixZ'), ('OlrichZ'), ('JoshuaZ');
GO

BEGIN TRANSACTION;

UPDATE customers
SET name = LEFT(name, LEN(name) - 1)
WHERE RIGHT(name, 1) = 'Z';

COMMIT TRANSACTION;