I'm sorry this took me so long - but thank you. This is actually much
cleaner syntax and I like it.
Thanks for all you do!
On Mon, Aug 12, 2019 at 8:44 PM Mike Bayer wrote:
>
>
> On Mon, Aug 12, 2019, at 5:49 PM, Michael P. McDonnell wrote:
>
> Hey team -
>
> I'm trying to figure out how to
On Mon, Aug 12, 2019, at 5:49 PM, Michael P. McDonnell wrote:
> Hey team -
>
> I'm trying to figure out how to basically rewrite this:
> SELECT
> count(task.id)
> FROM task
> JOIN round on task.game_id = round.game_id
> JOIN tournament ON round.tournament_id = tournament.id
> WHERE
Hey team -
I'm trying to figure out how to basically rewrite this:
SELECT
count(task.id)
FROM task
JOIN round on task.game_id = round.game_id
JOIN tournament ON round.tournament_id = tournament.id
WHERE tournament.id = '626aeaa7-783b-415c-85f9-5222d9c95973';
As this:
total_tasks =