-- Create the table
CREATE TABLE teams (
    team_name VARCHAR(50) NOT NULL
);

-- Insert team names
INSERT INTO teams (team_name) VALUES 
('CSK'),
('KKR'),
('GT'),
('DC'),
('LSG');

with ct as (
select * , row_number() over(order by team_name) as row_id
from teams
    )
select c1.team_name as team_1, c2.team_name as team_2
    from ct c1
    join ct c2 on c1.row_id<c2.row_id;

Embed on website

To embed this project on your website, copy the following code and paste it into your website's HTML: