---
title: "do_clean_start.sql"
url: "https://docs.yugabyte.com/stable/api/ysql/exprs/window_functions/analyzing-a-normal-distribution/do-clean-start/"
---

# do_clean_start.sql

do_clean_start.sql - Part of the code kit for the "Analyzing a normal distribution" section within the YSQL window functions documentation.

Save this script as `do_clean_start.sql`.

```plpgsql
-- Get a clean start.
-- These tables will store some query results so that, with
-- all these in a single table, it is easy to use
-- SQL to compare results from different tests.

set client_min_messages = warning;
drop table if exists dp_results cascade;
create table dp_results(
  method  text              not null,
  bucket  int               not null,
  n       int               not null,
  min_s   double precision  not null,
  max_s   double precision  not null,

  constraint dp_results_pk primary key(method, bucket));

drop table if exists int_results cascade;
create table int_results(
  method  text              not null,
  bucket  int               not null,
  n       int               not null,
  min_s   double precision  not null,
  max_s   double precision  not null,

  constraint int_results_pk primary key(method, bucket));
```