mysql腾讯面试题（听说半个小时做出来的可以提价18000+，附有sql文本和解题代码和题目要求）

-- Q1
select order_datetime,
       dc.province_id,
       province_name,
       dim_store.store_id,
       unit_price,
       sum(unit_price)over(partition by province_name)
from fact_order_detail
    join dim_store
    join dim_city dc
    join dim_province dp on dc.province_id = dp.province_id
;
-- 将查询数据保存到一个临时表中
create  table temp_table as
with demo as (select order_datetime, MONTH(order_datetime),store_id,unit_price
from fact_order_detail)

select month(order_datetime) as `month`,province_name,city_name,store_id,unit_price
from dim_province
left join dim_city dc on dim_province.province_id = dc.province_id
left join demo
on store_id = demo.store_id;-- 关联省份 城市 省份 店铺
drop table temp_table;


select `month`,province_name,sum(unit_price)
from temp_table
group by province_name, `month`
;

-- Q2
select month(order_datetime),product_id,unit_price/sum(unit_price) over(partition by product_id)
from fact_order_detail
;

-- Q3
select month(order_datetime) mon,sum(unit_price)over(partition by month(order_datetime))as sum1
from fact_order_detail
order by month(order_datetime);

create table temp_table2 as
select mon,sum(sum1)
from (select month(order_datetime) mon,sum(unit_price)over(partition by month(order_datetime)) as sum1
from fact_order_detail
order by month(order_datetime))as demo1
group by demo1.mon
;

select `sum(sum1)`,
       (`sum(sum1)`-sum(`sum(sum1)`) over(order by mon rows between 1 preceding and 1 preceding))
                       /sum(`sum(sum1)`) over(order by mon rows between 1 preceding and 1 preceding)  as 销售额环比
from temp_table2;

-- Q4
# 每个月消费的用户id 及其排序
create table temp_table3 as
select month(order_datetime) mon,user_id
from fact_order_detail
group by mon,user_id
order by mon,user_id
;

# 每个用户的购买次数
select temp.user_id,count(user_id)
from (select month(order_datetime),user_id
from fact_order_detail) as temp
group by temp.user_id;

# 一月产生消费的用户
select mon,user_id
from temp_table3
where mon = 1;

# 二月有一月没有的
select mon,user_id
from temp_table3
where user_id not in (select user_id
from temp_table3
where mon = 1) and mon = 2;

# 二月产生消费的用户
select mon,user_id
from temp_table3
where mon = 2;
# 三月有二月没有的用户
select mon,user_id
from temp_table3
where user_id not in (select user_id
from temp_table3
where mon = 2) and mon = 3;

# 一月的消费个数
select count(user_id)
from temp_table3
where mon = 1;

# 二月消费id在一月也消费过的个数
select count(user_id)
from temp_table3
where user_id in (select user_id
from temp_table3
where mon = 1)  and mon=2;

# 一月到二月的留存率为5/6

# 二月的消费个数
select count(user_id)
from temp_table3
where mon = 2; -- 6

# 三月消费id在一月也消费过的个数
select count(user_id)
from temp_table3
where user_id in (select user_id
from temp_table3
where mon = 2)  and mon=3; -- 3

# 二月到三月的留存率为 3/6 = 1/2

-- MySQL dump 10.13  Distrib 8.0.16, for Win64 (x86_64)
--
-- Host: localhost    Database: interview
-- ------------------------------------------------------
-- Server version    8.0.16

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
 SET NAMES utf8mb4 ;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


--
-- Create DataBase `interview`
--
CREATE DATABASE `interview` CHARSET=utf8;
USE interview;

--
-- Table structure for table `dim_city`
--

DROP TABLE IF EXISTS `dim_city`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `dim_city` (
  `city_id` varchar(30) DEFAULT NULL,
  `city_name` varchar(30) DEFAULT NULL,
  `province_id` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dim_city`
--

LOCK TABLES `dim_city` WRITE;
/*!40000 ALTER TABLE `dim_city` DISABLE KEYS */;
INSERT INTO `dim_city` VALUES ('110100','北京市','110000'),('120100','天津市','120000'),('130100','石家庄市','130000'),('130200','唐山市','130000'),('130300','秦皇岛市','130000'),('130400','邯郸市','130000'),('130500','邢台市','130000'),('130600','保定市','130000'),('130700','张家口市','130000'),('130800','承德市','130000'),('130900','沧州市','130000'),('131000','廊坊市','130000'),('131100','衡水市','130000'),('139000','省直辖县级行政区划','130000'),('140100','太原市','140000'),('140200','大同市','140000'),('140300','阳泉市','140000'),('140400','长治市','140000'),('140500','晋城市','140000'),('140600','朔州市','140000'),('140700','晋中市','140000'),('140800','运城市','140000'),('140900','忻州市','140000'),('141000','临汾市','140000'),('141100','吕梁市','140000'),('150100','呼和浩特市','150000'),('150200','包头市','150000'),('150300','乌海市','150000'),('150400','赤峰市','150000'),('150500','通辽市','150000'),('150600','鄂尔多斯市','150000'),('150700','呼伦贝尔市','150000'),('150800','巴彦淖尔市','150000'),('150900','乌兰察布市','150000'),('152200','兴安盟','150000'),('152500','锡林郭勒盟','150000'),('152900','阿拉善盟','150000'),('210100','沈阳市','210000'),('210200','大连市','210000'),('210300','鞍山市','210000'),('210400','抚顺市','210000'),('210500','本溪市','210000'),('210600','丹东市','210000'),('210700','锦州市','210000'),('210800','营口市','210000'),('210900','阜新市','210000'),('211000','辽阳市','210000'),('211100','盘锦市','210000'),('211200','铁岭市','210000'),('211300','朝阳市','210000'),('211400','葫芦岛市','210000'),('220100','长春市','220000'),('220200','吉林市','220000'),('220300','四平市','220000'),('220400','辽源市','220000'),('220500','通化市','220000'),('220600','白山市','220000'),('220700','松原市','220000'),('220800','白城市','220000'),('222400','延边朝鲜族自治州','220000'),('230100','哈尔滨市','230000'),('230200','齐齐哈尔市','230000'),('230300','鸡西市','230000'),('230400','鹤岗市','230000'),('230500','双鸭山市','230000'),('230600','大庆市','230000'),('230700','伊春市','230000'),('230800','佳木斯市','230000'),('230900','七台河市','230000'),('231000','牡丹江市','230000'),('231100','黑河市','230000'),('231200','绥化市','230000'),('232700','大兴安岭地区','230000'),('310100','上海市','310000'),('320100','南京市','320000'),('320200','无锡市','320000'),('320300','徐州市','320000'),('320400','常州市','320000'),('320500','苏州市','320000'),('320600','南通市','320000'),('320700','连云港市','320000'),('320800','淮安市','320000'),('320900','盐城市','320000'),('321000','扬州市','320000'),('321100','镇江市','320000'),('321200','泰州市','320000'),('321300','宿迁市','320000'),('330100','杭州市','330000'),('330200','宁波市','330000'),('330300','温州市','330000'),('330400','嘉兴市','330000'),('330500','湖州市','330000'),('330600','绍兴市','330000'),('330700','金华市','330000'),('330800','衢州市','330000'),('330900','舟山市','330000'),('331000','台州市','330000'),('331100','丽水市','330000'),('340100','合肥市','340000'),('340200','芜湖市','340000'),('340300','蚌埠市','340000'),('340400','淮南市','340000'),('340500','马鞍山市','340000'),('340600','淮北市','340000'),('340700','铜陵市','340000'),('340800','安庆市','340000'),('341000','黄山市','340000'),('341100','滁州市','340000'),('341200','阜阳市','340000'),('341300','宿州市','340000'),('341500','六安市','340000'),('341600','亳州市','340000'),('341700','池州市','340000'),('341800','宣城市','340000'),('350100','福州市','350000'),('350200','厦门市','350000'),('350300','莆田市','350000'),('350400','三明市','350000'),('350500','泉州市','350000'),('350600','漳州市','350000'),('350700','南平市','350000'),('350800','龙岩市','350000'),('350900','宁德市','350000'),('360100','南昌市','360000'),('360200','景德镇市','360000'),('360300','萍乡市','360000'),('360400','九江市','360000'),('360500','新余市','360000'),('360600','鹰潭市','360000'),('360700','赣州市','360000'),('360800','吉安市','360000'),('360900','宜春市','360000'),('361000','抚州市','360000'),('361100','上饶市','360000'),('370100','济南市','370000'),('370200','青岛市','370000'),('370300','淄博市','370000'),('370400','枣庄市','370000'),('370500','东营市','370000'),('370600','烟台市','370000'),('370700','潍坊市','370000'),('370800','济宁市','370000'),('370900','泰安市','370000'),('371000','威海市','370000'),('371100','日照市','370000'),('371200','莱芜市','370000'),('371300','临沂市','370000'),('371400','德州市','370000'),('371500','聊城市','370000'),('371600','滨州市','370000'),('371700','菏泽市','370000'),('410100','郑州市','410000'),('410200','开封市','410000'),('410300','洛阳市','410000'),('410400','平顶山市','410000'),('410500','安阳市','410000'),('410600','鹤壁市','410000'),('410700','新乡市','410000'),('410800','焦作市','410000'),('410900','濮阳市','410000'),('411000','许昌市','410000'),('411100','漯河市','410000'),('411200','三门峡市','410000'),('411300','南阳市','410000'),('411400','商丘市','410000'),('411500','信阳市','410000'),('411600','周口市','410000'),('411700','驻马店市','410000'),('419000','省直辖县级行政区划','410000'),('420100','武汉市','420000'),('420200','黄石市','420000'),('420300','十堰市','420000'),('420500','宜昌市','420000'),('420600','襄阳市','420000'),('420700','鄂州市','420000'),('420800','荆门市','420000'),('420900','孝感市','420000'),('421000','荆州市','420000'),('421100','黄冈市','420000'),('421200','咸宁市','420000'),('421300','随州市','420000'),('422800','恩施土家族苗族自治州','420000'),('429000','省直辖县级行政区划','420000'),('430100','长沙市','430000'),('430200','株洲市','430000'),('430300','湘潭市','430000'),('430400','衡阳市','430000'),('430500','邵阳市','430000'),('430600','岳阳市','430000'),('430700','常德市','430000'),('430800','张家界市','430000'),('430900','益阳市','430000'),('431000','郴州市','430000'),('431100','永州市','430000'),('431200','怀化市','430000'),('431300','娄底市','430000'),('433100','湘西土家族苗族自治州','430000'),('440100','广州市','440000'),('440200','韶关市','440000'),('440300','深圳市','440000'),('440400','珠海市','440000'),('440500','汕头市','440000'),('440600','佛山市','440000'),('440700','江门市','440000'),('440800','湛江市','440000'),('440900','茂名市','440000'),('441200','肇庆市','440000'),('441300','惠州市','440000'),('441400','梅州市','440000'),('441500','汕尾市','440000'),('441600','河源市','440000'),('441700','阳江市','440000'),('441800','清远市','440000'),('441900','东莞市','440000'),('442000','中山市','440000'),('445100','潮州市','440000'),('445200','揭阳市','440000'),('445300','云浮市','440000'),('450100','南宁市','450000'),('450200','柳州市','450000'),('450300','桂林市','450000'),('450400','梧州市','450000'),('450500','北海市','450000'),('450600','防城港市','450000'),('450700','钦州市','450000'),('450800','贵港市','450000'),('450900','玉林市','450000'),('451000','百色市','450000'),('451100','贺州市','450000'),('451200','河池市','450000'),('451300','来宾市','450000'),('451400','崇左市','450000'),('460100','海口市','460000'),('460200','三亚市','460000'),('460300','三沙市','460000'),('460400','儋州市','460000'),('469000','省直辖县级行政区划','460000'),('500100','重庆市','500000'),('500200','县','500000'),('510100','成都市','510000'),('510300','自贡市','510000'),('510400','攀枝花市','510000'),('510500','泸州市','510000'),('510600','德阳市','510000'),('510700','绵阳市','510000'),('510800','广元市','510000'),('510900','遂宁市','510000'),('511000','内江市','510000'),('511100','乐山市','510000'),('511300','南充市','510000'),('511400','眉山市','510000'),('511500','宜宾市','510000'),('511600','广安市','510000'),('511700','达州市','510000'),('511800','雅安市','510000'),('511900','巴中市','510000'),('512000','资阳市','510000'),('513200','阿坝藏族羌族自治州','510000'),('513300','甘孜藏族自治州','510000'),('513400','凉山彝族自治州','510000'),('520100','贵阳市','520000'),('520200','六盘水市','520000'),('520300','遵义市','520000'),('520400','安顺市','520000'),('520500','毕节市','520000'),('520600','铜仁市','520000'),('522300','黔西南布依族苗族自治州','520000'),('522600','黔东南苗族侗族自治州','520000'),('522700','黔南布依族苗族自治州','520000'),('530100','昆明市','530000'),('530300','曲靖市','530000'),('530400','玉溪市','530000'),('530500','保山市','530000'),('530600','昭通市','530000'),('530700','丽江市','530000'),('530800','普洱市','530000'),('530900','临沧市','530000'),('532300','楚雄彝族自治州','530000'),('532500','红河哈尼族彝族自治州','530000'),('532600','文山壮族苗族自治州','530000'),('532800','西双版纳傣族自治州','530000'),('532900','大理白族自治州','530000'),('533100','德宏傣族景颇族自治州','530000'),('533300','怒江傈僳族自治州','530000'),('533400','迪庆藏族自治州','530000'),('540100','拉萨市','540000'),('540200','日喀则市','540000'),('540300','昌都市','540000'),('540400','林芝市','540000'),('540500','山南市','540000'),('542400','那曲地区','540000'),('542500','阿里地区','540000'),('610100','西安市','610000'),('610200','铜川市','610000'),('610300','宝鸡市','610000'),('610400','咸阳市','610000'),('610500','渭南市','610000'),('610600','延安市','610000'),('610700','汉中市','610000'),('610800','榆林市','610000'),('610900','安康市','610000'),('611000','商洛市','610000'),('620100','兰州市','620000'),('620200','嘉峪关市','620000'),('620300','金昌市','620000'),('620400','白银市','620000'),('620500','天水市','620000'),('620600','武威市','620000'),('620700','张掖市','620000'),('620800','平凉市','620000'),('620900','酒泉市','620000'),('621000','庆阳市','620000'),('621100','定西市','620000'),('621200','陇南市','620000'),('622900','临夏回族自治州','620000'),('623000','甘南藏族自治州','620000'),('630100','西宁市','630000'),('630200','海东市','630000'),('632200','海北藏族自治州','630000'),('632300','黄南藏族自治州','630000'),('632500','海南藏族自治州','630000'),('632600','果洛藏族自治州','630000'),('632700','玉树藏族自治州','630000'),('632800','海西蒙古族藏族自治州','630000'),('640100','银川市','640000'),('640200','石嘴山市','640000'),('640300','吴忠市','640000'),('640400','固原市','640000'),('640500','中卫市','640000'),('650100','乌鲁木齐市','650000'),('650200','克拉玛依市','650000'),('650400','吐鲁番市','650000'),('650500','哈密市','650000'),('652300','昌吉回族自治州','650000'),('652700','博尔塔拉蒙古自治州','650000'),('652800','巴音郭楞蒙古自治州','650000'),('652900','阿克苏地区','650000'),('653000','克孜勒苏柯尔克孜自治州','650000'),('653100','喀什地区','650000'),('653200','和田地区','650000'),('654000','伊犁哈萨克自治州','650000'),('654200','塔城地区','650000'),('654300','阿勒泰地区','650000'),('659000','自治区直辖县级行政区划','650000');
/*!40000 ALTER TABLE `dim_city` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dim_product`
--

DROP TABLE IF EXISTS `dim_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `dim_product` (
  `product_id` int(11) DEFAULT NULL,
  `product_name` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dim_product`
--

LOCK TABLES `dim_product` WRITE;
/*!40000 ALTER TABLE `dim_product` DISABLE KEYS */;
INSERT INTO `dim_product` VALUES (1,'手机'),(2,'电视'),(3,'空调'),(4,'洗衣机'),(5,'笔记本'),(6,'路由器');
/*!40000 ALTER TABLE `dim_product` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dim_province`
--

DROP TABLE IF EXISTS `dim_province`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `dim_province` (
  `province_id` varchar(30) DEFAULT NULL,
  `province_name` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dim_province`
--

LOCK TABLES `dim_province` WRITE;
/*!40000 ALTER TABLE `dim_province` DISABLE KEYS */;
INSERT INTO `dim_province` VALUES ('110000','北京市'),('120000','天津市'),('130000','河北省'),('140000','山西省'),('150000','内蒙古自治区'),('210000','辽宁省'),('220000','吉林省'),('230000','黑龙江省'),('310000','上海市'),('320000','江苏省'),('330000','浙江省'),('340000','安徽省'),('350000','福建省'),('360000','江西省'),('370000','山东省'),('410000','河南省'),('420000','湖北省'),('430000','湖南省'),('440000','广东省'),('450000','广西壮族自治区'),('460000','海南省'),('500000','重庆市'),('510000','四川省'),('520000','贵州省'),('530000','云南省'),('540000','西藏自治区'),('610000','陕西省'),('620000','甘肃省'),('630000','青海省'),('640000','宁夏回族自治区'),('650000','新疆维吾尔自治区'),('710000','台湾省'),('810000','香港特别行政区'),('820000','澳门特别行政区');
/*!40000 ALTER TABLE `dim_province` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dim_store`
--

DROP TABLE IF EXISTS `dim_store`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `dim_store` (
  `store_id` varchar(32) DEFAULT NULL,
  `store_name` varchar(32) DEFAULT NULL,
  `city_id` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dim_store`
--

LOCK TABLES `dim_store` WRITE;
/*!40000 ALTER TABLE `dim_store` DISABLE KEYS */;
INSERT INTO `dim_store` VALUES ('s1','s1-店铺名','411600'),('s2','s2-店铺名','350500'),('s3','s3-店铺名','360400'),('s4','s4-店铺名','370100'),('s5','s5-店铺名','370200'),('s6','s6-店铺名','320600'),('s7','s7-店铺名','320800'),('s8','s8-店铺名','330100'),('s9','s9-店铺名','330300'),('s10','s10-店铺名','330400');
/*!40000 ALTER TABLE `dim_store` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dim_user`
--

DROP TABLE IF EXISTS `dim_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `dim_user` (
  `user_id` int(11) DEFAULT NULL,
  `user_name` varchar(32) DEFAULT NULL,
  `city_id` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dim_user`
--

LOCK TABLES `dim_user` WRITE;
/*!40000 ALTER TABLE `dim_user` DISABLE KEYS */;
INSERT INTO `dim_user` VALUES (1,'smart','411600'),(2,'lucy','350500'),(3,'david','360400'),(4,'jack','370100'),(5,'rose','370200'),(6,'linda','320600'),(7,'gavin','320800'),(8,'mary','330100'),(9,'alice','330300'),(10,'joan','330400');
/*!40000 ALTER TABLE `dim_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fact_order_detail`
--

DROP TABLE IF EXISTS `fact_order_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `fact_order_detail` (
  `order_datetime` datetime DEFAULT NULL,
  `order_id` varchar(32) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `store_id` varchar(32) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `unit_price` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fact_order_detail`
--

LOCK TABLES `fact_order_detail` WRITE;
/*!40000 ALTER TABLE `fact_order_detail` DISABLE KEYS */;
INSERT INTO `fact_order_detail` VALUES ('2021-01-01 00:00:00','10000001',2,1,'s1',1,2500.00),('2021-01-01 00:00:00','10000002',2,2,'s2',1,2500.00),('2021-01-03 00:00:00','10000003',1,3,'s3',1,4900.00),('2021-01-10 00:00:00','10000004',3,4,'s4',1,2000.00),('2021-01-21 00:00:00','10000005',6,5,'s5',3,200.00),('2021-01-23 00:00:00','10000006',6,9,'s9',2,200.00),('2021-02-01 00:00:00','10000007',1,1,'s1',1,2400.00),('2021-02-02 00:00:00','10000008',3,3,'s3',1,4000.00),('2021-02-03 00:00:00','10000009',2,5,'s5',3,2000.00),('2021-02-18 00:00:00','10000010',6,7,'s7',2,200.00),('2021-02-24 00:00:00','10000011',1,9,'s9',3,2400.00),('2021-02-28 00:00:00','10000012',1,4,'s4',5,7500.00),('2021-03-03 00:00:00','10000013',4,1,'s1',2,4800.00),('2021-03-08 00:00:00','10000014',5,7,'s7',1,4000.00),('2021-03-10 00:00:00','10000015',2,6,'s6',4,8000.00),('2021-03-11 00:00:00','10000016',3,8,'s8',1,300.00),('2021-03-20 00:00:00','10000017',1,10,'s10',5,1600.00),('2021-03-20 00:00:00','10000018',3,3,'s10',3,300.00),('2021-03-20 00:00:00','10000019',3,1,'s1',3,900.00);
/*!40000 ALTER TABLE `fact_order_detail` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-01-08 21:25:27