Quick SQL to build tables with example data

create_table.sql

-- Creates list of bookings
create table bookings as
  with
      date_table as (select now()::date - generate_series(0, 7 * 10000) as date),
      hour_table as (select generate_series(0, 24) as hour),
      time_table as (
        select 
          date_table.date::date as date,
          extract(year from date_table.date) as year,
          extract(month from date_table.date) as month,
          extract(day from date_table.date) as day,
          hour_table.hour
      from date_table CROSS JOIN hour_table
  )
  SELECT 
    floor(random() * 100 + 1)::int as product_id,
    date,
    year,
    month,
    day,
    hour
  from time_table;

-- Creates list of product.id
create table products as
  select generate_series(1,100) as id;