-- 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;
To embed this project on your website, copy the following code and paste it into your website's HTML: