北京小公司SQL笔试题CREATE TABLE IF NOT EXISTS order( loan_id BIGINT COMMENT '订单ID' ,apply_time DATETIME COMMENT '申请时间' ,customer_id BIGINT COMMENT '客户id' ,is_success_loan STRING COMMENT '是否成功放款,1:放款成功、0:放款时间' ,principal DOUBLE COMMENT '合同金额' ,product_id INT COMMENT '产品id')COMMENT 'TABLE COMMENT';CREATE TABLE IF NOT EXISTS customer( customer_id BIGINT COMMENT '客户id' ,age INT COMMENT '年龄')COMMENT 'TABLE COMMENT';CREATE TABLE IF NOT EXISTS product( product_id BIGINT COMMENT '产品id' ,product_name STRING COMMENT '产品名称')COMMENT 'TABLE COMMENT';--近10天年龄在30-40岁的每天申请量和成功放款金额 --近5个月,连续三个月都放过款的用户信息