Archives
Trending
Support
Login
clear text
XML
Django
JavaScript
MATLAB
C
C++
C#
Python
SQL
Shell
Bash
Markdown
YAML
JSON
HTML
CSS
PHP
Java
Ruby
Go
Rust
Swift
Kotlin
Arduino
TypeScript
Perl
Autohotkey
Lua
SQF
R
Scala
Haskell
Groovy
Dart
Clojure
VB.NET
Objective-C
PowerShell
Bash
CoffeeScript
Verilog
WITH usrs AS (SELECT * FROM (SELECT user_id FROM tools_shop.orders) AS o LEFT JOIN (SELECT user_id FROM tools_shop.users) AS u ON o.user_id = u.user_id LEFT JOIN tools_shop.events AS e ON e.user_id = o.user_id), ord AS (SELECT CAST(DATE_TRUNC('month', event_time) AS date) AS mnth, COUNT(event_name) AS cnt FROM usrs GROUP BY CAST(DATE_TRUNC('month', event_time) AS date)) SELECT *, sum(cnt) OVER ( ORDER BY mnth) FROM ord
Mark as private (unlisted)
for 30 minutes
for 6 hours
for 1 day
for 1 week
for 1 month
for 1 year
everlasting (like CCCP)
