| SELECT log_actor, log_type, COUNT(1)
FROM logging
JOIN actor ON log_actor =... |
2 years ago |
| SELECT log_actor, log_type, COUNT(1)
FROM logging
JOIN actor ON log_actor =... |
2 years ago |
| SELECT RANK() OVER (ORDER BY reviews DESC) AS rank, user_name,... |
2 years ago |
| SELECT RANK() OVER (ORDER BY reviews DESC) AS rank; user_name,... |
2 years ago |
| SELECT user_name, COUNT(log_actor)
FROM logging
JOIN actor ON log_actor =... |
2 years ago |
| SELECT user_name, COUNT(log_actor)
FROM logging
JOIN actor ON log_actor =... |
2 years ago |
| SELECT user_name, COUNT(user_name)
FROM logging
JOIN user on log_user =... |
2 years ago |
| SELECT user_name, COUNT(log_user)
FROM logging
JOIN user on log_user =... |
2 years ago |
