mysql - select 在这个位置无效----MYSQL 快把我逼疯了

Question

我正在做 MYSQL，即使我完全按照在线类(class)脚本输入，错误仍然弹出

它一直说“SELECT 在这个版本的这个位置无效......”有人可以帮忙吗？下面是脚本

use mavenfuzzyfactory;


SELECT 
website_sessions.device_type, 
count(distinct website_session.website_session_id) AS session,
count(distinct order.order_id) AS orders

FROM website_sessions

left join 
on website_session.websit_session_id= order.website_session_id

WHERE website_sessions.created_at< '2012-05-11'
      AND utm_source= 'gsearch'
      AND utm_campaign= 'nonbrand'
GROUP BY 1

Answer 1

也许你想要这个...

SELECT s.device_type
     , count(distinct s.website_session_id) session
     , count(distinct o.order_id) orders
  FROM website_sessions s
  left 
  join `order` o
    on o.website_session_id = s.websit_session_id 
 WHERE s.created_at < '2012-05-11'
   AND utm_source = 'gsearch'
   AND utm_campaign= 'nonbrand'
 GROUP 
    BY 1