I need to track the sequence of sites visited by a user in their session. My data looks like this: visitor session_num site page_view_num timestamp User A 2 Site A 1 2024-03-22 11:41:10 User A 2 Site A 2 2024-03-22…
I'm querying Vertica using node-vertica npm packge (Node server), I noticed that every time the ROUND expression is 0/null, I'm getting the error - ERROR: Schema "pg_catalog" does not exist. EDIT: For example: SELECT name, email, ROUND(SUM(grade)/nullifzero(count(grade))) as avrage ---->…
I have a table with the following structure: +------+--------------+--------------+ | SHOP | BUY_PROFIT | SELL_PROFIT | +------+--------------+--------------+ | A | 10 | 15 | +------+--------------+--------------+ I need to write select statement to make it look like this: +------+------+--------+ | SHOP…