Thanks @Landan George​ 

Since "streaming_silver" is a streaming live table, I expected the last line of the code to be:

AS SELECT count(*) FROM STREAM(LIVE.streaming_silver) GROUP BY user_id

But, as you can see the "live_gold" is defined by:

AS SELECT count(*) FROM LIVE.streaming_silver GROUP BY user_id