听闻M家待遇不错,又是国企。
但是去到第一天就觉得坑爹,太偏僻了,饭堂太难吃了,工作环境太烂了。
第一面算是笔试,带个电脑去到他们那,写代码。一个是socket通信。一个是sql语句。socket上午就写完了,sql的不会....用到好多高深的东西...如最后。
然后二面。二面是自我介绍,还有一些聊人生,你在哪的啊,家人呢,以后打算留在这城市吗,你怎么看待国企和IT私企的啊等等。政治立场不能错误...
这一面还问了些技术的问题。但是这些问题很细很细,除非是刚考完试,否则真的答不上来,被鄙视。
然后三面。三面很无聊,一群人依次自我介绍,给领导听听。这里,我觉得我的自我介绍有点问题,讲的东西太高端大气上档次了,什么数据挖掘,什么数据可视化等等,要实际点。在国企里,可能做的东西不会太高深,不如讲得踏实点。
然后叫我去笔试。算了,我觉得我不会去的了.....
-------------------------------------------
一,表的建立:
--生成Point
create table Point (PointName varchar(20) primary key, SectorName varchar(10));
insert into Point values('YIN', 'ACC1');
insert into Point values('SHL', 'ACC1');
insert into Point values('IDUMA', 'ACC2');
insert into Point values('BEKOL', 'ACC2');
--生成FlyLog
create table FlyLog (FlyLogID int primary key auto_increment, FlightID int, PointName varchar(20), FlyTime datetime,foreign key(PointName) references Point(PointName));
insert into FlyLog values(1, 13283, 'YIN', '2013-09-11 10:03');
insert into FlyLog values(2, 13283, 'SHL', '2013-09-11 10:09');
insert into FlyLog values(3, 13283, 'IDUMA', '2013-09-11 10:11');
insert into FlyLog values(7, 13562, 'BEKOL', '2013-09-11 10:05');
二,对表进行处理:
1. INNER JOIN:
select FlyLogID, FlightID, FlyLog.PointName, FlyTime, Point.SectorName from FlyLog INNER JOIN Point ON FlyLog.PointName = Point.PointName;
2: CASE WHEN:
select FlyLogID, FlightID, FlyLog.PointName, Point.SectorName, case when FlyTime >='2013-09-11 10:00' and FlyTime <= '2013-09-11 10:05' then '2013-09-11 10:00' when FlyTime >'2013-09-11 10:05' and FlyTime <= '2013-09-11 10:10' then '2013-09-11 10:05' when FlyTime >'2013-09-11 10:10' and FlyTime <= '2013-09-11 10:15' then '2013-09-11 10:10' ELSE NULL END from FlyLog INNER JOIN Point ON FlyLog.PointName = Point.PointName;
3: SUM CASE
select sum(case when FlyTime >='2013-09-11 10:00' and FlyTime <= '2013-09-11 10:05' then 1 else 0 END) as q1, Sum(case when FlyTime >'2013-09-11 10:05' and FlyTime <= '2013-09-11 10:10' then 1 else 0 END) as q2, sum(case when FlyTime >'2013-09-11 10:10' and FlyTime <= '2013-09-11 10:15' then 1 else 0 END) as q3 from FlyLog INNER JOIN Point ON FlyLog.PointName = Point.PointName group by Point.SectorName;
4: 行列互换—未完成