中国百家姓sql版

-- 创建临时表
drop table if exists fcmart.v_graph_hundred_family_names_temp
create table if not exists fcmart.v_graph_hundred_family_names_temp
( last_name_id string comment '编号',
  last_name string comment '姓氏',
  data_dt string comment '数据日期'
);

-- 插入数据
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('1','赵','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('2','钱','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('3','孙','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('4','李','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('5','周','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('6','吴','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('7','郑','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('8','王','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('9','冯','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('10','陈','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('11','褚','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('12','卫','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('13','蒋','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('14','沈','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('15','韩','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('16','杨','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('17','朱','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('18','秦','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('19','尤','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('20','许','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('21','何','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('22','吕','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('23','施','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('24','张','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('25','孔','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('26','曹','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('27','严','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('28','华','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('29','金','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('30','魏','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('31','陶','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('32','姜','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('33','戚','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('34','谢','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('35','邹','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('36','喻','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('37','柏','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('38','水','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('39','窦','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('40','章','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('41','云','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('42','苏','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('43','潘','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('44','葛','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('45','奚','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('46','范','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('47','彭','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('48','郎','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('49','鲁','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('50','韦','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('51','昌','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('52','马','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('53','苗','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('54','凤','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('55','花','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('56','方','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('57','俞','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('58','任','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('59','袁','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('60','柳','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('61','酆','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('62','鲍','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('63','史','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('64','唐','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('65','费','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('66','廉','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('67','岑','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('68','薛','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('69','雷','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('70','贺','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('71','倪','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('72','汤','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('73','滕','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('74','殷','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('75','罗','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('76','毕','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('77','郝','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('78','邬','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('79','安','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('80','常','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('81','乐','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('82','于','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('83','时','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('84','傅','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('85','皮','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('86','卞','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('87','齐','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('88','康','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('89','伍','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('90','余','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('91','元','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('92','卜','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('93','顾','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('94','孟','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('95','平','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('96','黄','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('97','和','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('98','穆','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('99','萧','202109008');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('100','尹','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('101','姚','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('102','邵','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('103','湛','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('104','汪','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('105','祁','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('106','毛','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('107','禹','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('108','狄','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('109','米','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('110','贝','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('111','明','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('112','臧','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('113','计','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('114','伏','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('115','成','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('116','戴','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('117','谈','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('118','宋','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('119','茅','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('120','庞','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('121','熊','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('122','纪','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('123','舒','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('124','屈','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('125','项','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('126','祝','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('127','董','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('128','梁','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('129','杜','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('130','阮','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('131','蓝','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('132','闵','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('133','席','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('134','季','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('135','麻','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('136','强','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('137','贾','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('138','路','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('139','娄','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('140','危','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('141','江','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('142','童','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('143','颜','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('144','郭','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('145','梅','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('146','盛','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('147','林','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('148','刁','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('149','锺','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('150','徐','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('151','邱','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('152','骆','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('153','高','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('154','夏','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('155','蔡','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('156','田','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('157','樊','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('158','胡','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('159','凌','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('160','霍','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('161','虞','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('162','万','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('163','支','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('164','柯','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('165','昝','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('166','管','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('167','卢','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('168','莫','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('169','经','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('170','房','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('171','裘','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('172','缪','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('173','干','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('174','解','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('175','应','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('176','宗','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('177','丁','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('178','宣','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('179','贲','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('180','邓','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('181','郁','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('182','单','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('183','杭','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('184','洪','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('185','包','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('186','诸','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('187','左','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('188','石','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('189','崔','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('190','吉','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('191','钮','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('192','龚','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('193','程','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('194','嵇','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('195','邢','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('196','滑','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('197','裴','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('198','陆','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('199','荣','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('200','翁','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('201','荀','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('202','羊','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('203','於','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('204','惠','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('205','甄','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('206','麴','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('207','家','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('208','封','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('209','芮','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp values('210','羿','20210908');
INSERT INTO fcmart.v_graph_hundred_family_names_temp