3D之家预测

10个Excel常用操作,SQL也能实现啦!附面试原题

2020-02-12 投稿人 : sygthx.com 围观 : 1212 次

06.MOHUSHAIXUANSHUJU

Demand :SHAIXUANKUCUNMINGCHENGBAOHAN“SANXING”HUO“SUONI”XINXI。

07。XIAOJI

XUQIU:BEIJINGDIQUSUOYOUXIAOSHOURENYUANDEZONGLIRUN。

08。TIAOJIANJISUAN

XUQIU:KUCUNMINGCHENGZHONGBAOHAN“SANXING”QIESHUILVGAOYU1000DEDINGDANYOUDUOSHAO?ZHEIXIEDINGDANDEZONGLIRUNHEPINGJUNLIRUNSHIDUOSHAO?

3D之家预测#ZHEIXIEDINGDANDEZONGLIRUNHEPINGJUNLIRUNSHIDUOSHAO?CONGXIAOSHOUKUCUNMINGCHENGZHONGXUANZE“ordernum”、sum(LIRUN)、avg(LIRUN),RU“% samsung%”HE“tax”1000 group by“order num”;

09。SHANCHUSHUJU

3D之家预测XUQIUZHIJIANDEKONGGE:SHANCHUKUCUNMINGCHENGLIANGCEDEKONGGE。

10。HEBINGHEPAIXULIE

YAOQIU:JISUANMEIGEDINGDANBIANHAODECHENGBENBINGCONGGAODAODIPAIXU(CHENGBEN=BUHANSHUILIRUNDEJINE)

3D之家预测ZHAIYAO:JIEGOUHUACHAXUNYUYAN(SQL)SHISQLDESUOXIE。TAZHENDEHETADEMINGZIYIYANG。CHAXUNHENRONGYI,DANSHIDANGSHEJIDAOSHUJUCHULISHI,TABIPythonHEexcelGENGNAN(HUOZHEWOKENENGMEIYOUXUEHAOorz)。

ZHAIYAO:JIEGOUHUACHAXUNYUYAN(SQL)SHISQLDESUOXIE。TAZHENDEHETADEMINGZIYIYANG。CHAXUNHENRONGYI,DANSHIDANGSHEJIDAOSHUJUCHULISHI,TABIPythonHEexcelGENGNAN(HUOZHEWOKENENGMEIYOUXUEHAOorz)。

aSHUJUFUWUGONGSI:

XUESHENG:

score

3D之家预测(1)CHAXUNXUESHENGBIAOZHONGSUOYOUJILUDESname、SsexHEClassLIE。

(2)ZAIPINGFENBIAOZHONGCHAXUNSUOYOUDEFENZAI60DAO80ZHIJIANDEJILU。

(3)CHAXUNBANHEBANDEPINGJUNCHENGJI。

JIANERYANZHI,ZHEISHIYIGEXIANGDUIJIANDANDESQL penCESHI,ZAIDANGSHIWANCHENGDEFEICHANGKUAI。SHISHISHANG,ZHEIBUSHIZUICHUDEWENTI,DANWODEYINXIANGSHI,JIANCHAZHEIXIEWENTIHENJIANDAN。

SHOUYOUGONGSIDESQL penSHITI(YUANTI)

(1)XIEXIAJIANLIXUESHENGBIAODEYUJU,GAIBIAOYOUWUGESHUXINGZUCHENG:XUESHENGHAOSno、XINGMINGSname、XINGBIESsex、NIANLINGSageHEXISdept。QIZHONG,XUESHENGBIANHAOSHUXINGBUNENGWEIKONG,QIZHISHIWEIYIDE。

3D之家预测(2)ZAIXUESHENGBIAOZHONGCHAXUNXUESHENGDESUOYOUXINXI,BINGANSNOLIEPAIXU。

(3)ZAIYISHANGSANGEBIAOGEZHONGCHAZHAOXUEFENWEI5、NIANJIDAYU60DEXUESHENGDEXUEHAO、XINGMINGHEXINGBIE。

3D之家预测YIGEHULIANWANGJINRONGGONGSIDESQLBISHITI(YUANJIAN)

(1)BIAOJIAHEBIAOYIDEJIAOJI:

(2)BIAOJIAHEBIAOYIDEZUHE:

3D之家预测(3)BIAOJIAHEBIAOYIDEDUICHENGXINGCHAYI:

3D之家预测(4) CUNZAIYUBIAOAZHONGDANBUCUNZAIYUBIAOBZHONG:

LAIYUAN:zhhu

Zero Basic Employment Data Analysis Employment Class

CourseZHUYAOCAIYONG“SHISHIJILU”DEXINGSHI

3D之家预测ZHAOSHENGDUJIA:KECHENGXIANGMUJIATINGZUOYE1v1BANZHURENZAIaida data instituteXUESHENGZHUANYONGWANGZHANSHANGJIANDUXUEXIKETANGDAYIXIAOZU

KECHENGJIESHUHOU,TAKEYIZHANGWOSQL、Python、Excel、PPTDENGGONGJU

1。 GAIBIANTADEZHIYE(GANGWEIXIANGGUAN、ZHUANYEXIANGGUAN、DUISHUJUFENXIGANXINGQU)

3D之家预测2。CONGSHISHUJUFENXI,DANXUYAOTIGAOTADEJINENG,ZENGJIASHIZHANJINGYAN