SQL的奔溃时刻
一直报错，显示line4、line5错误，说我round语句用的不对
select
gender,university,
count(device_id) as user_num,
round(avg(active_days_within_30), 1) as avg_active_days,
round(avg(question_cnt), 1) as avg_question_cnt
from user_profile
group by
gender,
university;
改了很多次行不通
最后在line9加个分号就能运行了
太可恶了
想起了当年写matlab代码的苦日子
总结：语句结尾一定记住加分号“;”
#sql#
广电运通公司福利 310人发布