# BigQuery Public Datasets Query:
# Stack Overflow questions scoring 25+ deleted between March and December of 2017.
select
q.score as score,
concat(
"https://stackoverflow.com/questions/", string(q.id), "/",
rtrim(ltrim(regexp_replace(lower(q.title), r'[^0-9a-z]+', '-'), '-'), '-')
) as url,
if(q_june.id is null, "201703March - 201706June", if(
q_september.id is null, "201706June - 201709Sep", "201709Sep - 201712Dec"))
as deletion_window
from
[fh-bigquery:stackoverflow_archive.201703_posts_questions] q