Potrebna mi je pomoc kako da resim ovaj query
tabela ima kolone
user_id, login, referrer...etc..
Code (sql):
SELECT "referrer", COUNT(*) AS "count" FROM "users" GROUP BY "referrer" ORDER BY "referrer"
SELECT "referrer", COUNT(*) AS "count" FROM "users" GROUP BY "referrer" ORDER BY "referrer"
Mi daje
Code:
referrer count
622 53
624 2
627 3
628 3
630 6
631 1
637 5
referrer count
622 53
624 2
627 3
628 3
630 6
631 1
637 5
kako bih sad mogao referrer zameniti 'login' vrednoscu? da ispise korisnikov user(referrov) a ne id...
Problem mi je sto je sve u istoj tabeli , user_id je integer a refferer text