Codewars postgres challenge pg::syntaxerror

Question

I'm doing a SQL challenge on Codewars.com. So far so good.

The challenge I'm trying to solve is https://www.codewars.com/kata/calculating-month-over-month-percentage-growth-rate/train/sql

And my SQL looks like:

select date_trunc('month', created_at)::date as date, 
  count(distinct created_at) as count, 
  100 * (count(*) - lag(count(*), 1) over (order by date)) / lag(count(*), 1) over (order by date)) || '%' as growth
from posts
group by date
order by date asc

however, the server keeps on returning me the PG::SyntaxError: ERROR: subquery in FROM must have an alias

I'm not an expert with Postgres, but I know that I have alias for date, count, and growth as is expected from the task.

What else am I missing?

Any help is welcome.

mutantkeyboard · Accepted Answer · 2018-09-11 16:16:44Z

1

Nevermind, I found an issue. I've had an extra bracket in this line:

100 * (count(*) - lag(count(*), 1) over (order by date)) / lag(count(*), 1) over (order by date)) || '%' as growth

It should have been:

100 * (count(*) - lag(count(*), 1) over (order by date)) / lag(count(*), 1) over (order by date) || '%' as growth

answered Sep 11, 2018 at 16:16

mutantkeyboard

1,7362 gold badges21 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Codewars postgres challenge pg::syntaxerror

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related