Untitled

From Abrupt Lechwe, 2 Months ago, written in Plain Text, viewed 45 times.

URL http://codebin.org/view/7032eea6 Embed

Download Paste or View Raw

SELECT CAST(DATE_TRUNC('month', event_time) as date) as month,
       COUNT(event_id) as event_month
FROM tools_shop.events
WHERE event_name LIKE '%view_item%'
GROUP BY month
 
 
syntax error at or near "SELECT"
 
SELECT CAST(DATE_TRUNC('month', event_time) as date) as month,
       COUNT(event_id) as event_month
FROM tools_shop.events
WHERE event_name LIKE '%view_item%'
GROUP BY month
 

Reply to "Untitled"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?