这是老师的代码:
这是我的代码:
SELECT city,count(1) FROM date.dateanalyst
group by city
having count(if(industryField like "%电子商务%",1,null))>= 50
;
数据库错字没关系。
但是一直报错1046:
Error Code: 1046. No database selected
Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar. 0.000 sec