SQLコンテスト用のエディタのオートコンプリートです。

First_Value(■■■) over(partition by ■■■ order by ■■■)
Lag(■■■) over(partition by ■■■ order by ■■■)
Lead(■■■) over(partition by ■■■ order by ■■■)
Like
NTile(■■■) over(partition by ■■■ order by ■■■)
Row_Number() over(partition by ■■■ order by ■■■)
Rows between Unbounded Preceding and Unbounded Following
between ■■■ and ■■■
case when ■■■ then ■■■ else ■■■ end
count(*) from
delete from ■■■ where ■■■
distinct
exists(select 1 from ■■■ b where
group by
having
ifnull(
insert into ■■■ values(
is not null
is null
join ■■■ on
left Join ■■■ on
limit オフする行数 , 取得数
not exists(select 1 from ■■■ b where
nullif(
order by
over(partition by ■■■ order by ■■■)
partition by
range between Unbounded Preceding and Unbounded Following
replace(
select * from ■■■ where ■■■ order by ■■■;
union all select
update ■■■ set 
values(
with tmp as(