-- Create the UniqueID_practice Database if not exists
CREATE DATABASE IF NOT EXISTS UniqueID_practice;

-- Switch to the UniqueID_practice Database
USE UniqueID_practice;

-- Create the users2 Table
CREATE TABLE IF NOT EXISTS users2 (
    id INT AUTO_INCREMENT PRIMARY KEY,
    firstName VARCHAR(50),
    lastName VARCHAR(50),
    email VARCHAR(100)
);

-- Insert Records into the users2 Table
INSERT INTO users2 (firstName, lastName, email) VALUES
('John', 'Doe', 'john.doe@example.com'),
('Jane', 'Smith', 'jane.smith@example.com'),
('Alice', 'Johnson', 'alice.johnson@example.com'),
('YourFirstName', 'YourLastName', 'your.school.email@example.com');