CREATE TABLE users (

    id INT,

    name VARCHAR(50),

    date DATE

);

​

-- Insert test data

INSERT INTO users (id, name, date)

VALUES (1, 'John Doe', '2024-01-01'),

       (2, 'Jane Smith', '2024-01-02');

​

-- Test the SELECT statement with the same alias for different columns

SELECT 

    id, 

    name AS alias_name, 

    date AS alias_name 

FROM 

    users;

​

-- Clean up

DROP TABLE users;