SQL queries don't start with SELECT(jvns.ca)

  with data as
  (
   select *
   from
   (
    values(1), (2), (0), (4)
   ) as abc(d)
  )
  select 1 / d
  from data
  -- where d <> 0

  with data as
  (
   select *
   from
   (
    values(1), (2), (0), (4)
   ) as abc(d)
  )
  select case when d <> 0 then 1 / d else null end
  from data
  where d <> 0;

    select *
    from (select ...) as x
    where ...

    SELECT 2+2 as num FROM <table> HAVING num > 3;

    SELECT 2+2 as num FROM <table> HAVING num > 4;

  from u in User, where: u.id = 1, select: u.name

   select x.a, y.b, y.c
   from tableX x
   join (
     select id, sum(b) as b, count(b) as c 
     from tableY group by id
   ) as y on y.id = x.id

  drop schema if exists *