姓名：班级：学号：目录一、实验目的3二、实验内容3三、实验步骤3四、实验结果7实验目的熟练掌握SQL的数据定义/数据操作/查询功能。综合运用SQL处理实际问题。实验内容按照“”中“分摊表”提供的模板统计重庆唯胜气象信息有限公司开展“12121”业务情况。具体如下统计规则如下：1．数据源：共一张报表，见“”中“原始数据”2．取数规则见：“”中“取数规则”工作表中，即该公司在不同报表中取数约定。3．在“分摊表”中，城市、农村小灵通、未捆绑、捆绑取数在满足取数规则表.中约定外，产品名/用户群类型约定如下表1所示表1分摊说明类型分摊产品名/用户群类型固话分摊到城市or乡村除PHS、小灵通、语音CDMA外的其它类型小灵通分摊到小灵通PHS后付费小灵通预付费小灵通移动分摊到捆绑or未捆绑语音CDMA“”中“分摊表”的编制.实验步骤启动window2003操作系统，运行SQLServer2005,通过导入数据向导将“”中“原始数据”导入到数据库中。“原始数据”中不规范数据（主要是命名不一致）1)处理地区列数据处理用户类型列数据将sqlserver中数据重新命名,并且规范格式3按照要求用SQL分组统计出分成前收入如下表2所示：表2分成前收入地区城市农村小灵通移动未捆绑移动已捆绑合计巴南北碚……4然后借助于excel功能完善其它部分数据统计。实验结果分成前收入地区城市农村小灵通移动未捆绑移动已捆绑合计巴南7604.925110.732066.7612715.650.0012715.65北碚10572.662857.076281.1713429.730.0013429.73璧山4811.753289.163546.248100.910.008100.91长寿4436.714975.811522.459412.520.009412.52城口644.97867.56109.081512.530.001512.53大足1947.593381.54369.435329.130.005329.13垫江2068.913909.27370.805978.180.005978.18丰都2100.297825.15460.789925.440.009925.44奉节2011.545153.31661.907164.850.007164.85涪陵5780.499097.601592.3214878.090.0014878.09合川4334.767880.06845.5412214.820.0012214.82江津4087.779923.38988.9214011.150.0014011.15开县4823.8518021.94337.0122845.790.0022845.79梁平3240.718209.021055.5311449.730.0011449.73南川2472.724395.33366.206868.050.006868.05彭水758.435636.47159.926394.900.006394.90綦江2573.434046.65597.866620.080.006620.08黔江1488.711016.23339.642504.940.002504.94荣昌5554.453365.833770.548920.280.008920.28石柱902.321044.52305.671946.840.001946.84双桥1916.082.581372.151918.660.001918.66铜梁2989.665520.49488.768510.150.008510.15潼南1586.383075.80485.754662.180.004662.18万盛1056.621275.97200.992332.590.002332.59万州9079.9814156.652575.9823236.630.0023236.63巫山1560.802297.83444.003858.630.003858.63巫溪1377.489507.55309.1010885.030.0010885.03武隆642.143837.51141.024479.650.004479.65秀山1866.031250.83804.173116.860.003116.86永川6323.586792.382464.3513115.960.0013115.96酉阳936.272561.9682.413498.230.003498.23渝北7518.233592.092657.4711110.320.0011110.32云阳1949.917707.07414.229656.980.009656.98忠县2214.848277.