Back to browse
M-Schema
你现在是一名mysql数据分析专家,你的任务是根据参考的数据库schema和用户的问题,编写正确的SQL来回答用户的问题,生成的SQL用``sql 和```包围起来。 【数据库schema】 【DB_ID】 【Schema】 # Table: lc_namechange [ (InfoPublDate:LONGTEX…
Added May 19, 20260 views0 copies
Prompt
你现在是一名mysql数据分析专家,你的任务是根据参考的数据库schema和用户的问题,编写正确的SQL来回答用户的问题,生成的SQL用``sql 和```包围起来。 【数据库schema】 【DB_ID】 【Schema】 # Table: lc_namechange [ (InfoPublDate:LONGTEXT, Examples: [2019-01-16 12:00:00.000]), (ChangeDate:LONGTEXT, Examples: [2019-02-02 12:00:00.000]), (ChiNameAbbr:LONGTEXT, Examples: [中公教育, 新诺威, 大悦城控股]), (CompanyCode:BIGINT, Examples: [154266, 283573, 54]), (JSID:BIGINT, Examples: [604009310957, 725232072070, 748314568909]), (IfPassed:BIGINT, Examples: [0]), (XGRQ:LONGTEXT, Examples: [2019-02-20 08:21:50.957]), (InfoSource:LONGTEXT, Examples: [拟变更公司名称及证券简称的公告]), (ChiName:LONGTEXT, Examples: [中公教育科技股份有限公司, 石药集团新诺威制药股份有限公司, 大悦城控股集团股份有限公司]), (ID:BIGINT, Primary Key, Examples: [603230275798, 606430770076, 606504868609]), (EngName:LONGTEXT, Examples: [Offcn Education Technology Co., Ltd.]), (SMDeciPublDate:LONGTEXT, Examples: [2019-02-02 12:00:00.000]), (EngNameAbbr:LONGTEXT, Examples: [OFFCN EDU, GRANDJOY, YYTM]) ] # Table: lc_stockarchives [ (ContactTel:LONGTEXT, Examples: [0510-86632358, 010-67271828, 010-83433677]), (HShareAbbr:LONGTEXT, Examples: [新天绿色能源, 中石化油服]), (AShareAbbr:LONGTEXT, Examples: [双良节能, 国药股份, 中公教育]), (SecuAffairsReprEmail:LONGTEXT), (DisclosureWebsites:LONGTEXT), (SecretaryBD:LONGTEXT, Examples: [杨力康, 罗丽春, 王新汉]), (SecretaryBDEmail:LONGTEXT), (BriefIntroText:LONGTEXT), (CompanyCode:BIGINT, Examples: [1428, 1453, 154266]), (RedChipMark:LONGTEXT), (ConatactZipCode:LONGTEXT, Examples: [214444, 100077, 100089]), (JSID:BIGINT, Examples: [778877872162, 777937298667, 774981120857]), (BusinessMinor:LONGTEXT, Examples: [液压、锻件、铸件、换热器技术开发、转让、咨询服务、物流、机械冷热加工、修理修配服务。]), (BusinessMajor:LONGTEXT), (ID:BIGINT, Primary Key, Examples: [717016908274, 717502462977, 718558475818]), (InduCSRC:BIGINT, Examples: [13038, 16051, 26082]), (RegZipCode:LONGTEXT, Examples: [214444, 100077, 241000]), (IRegPlace:LONGTEXT, Examples: [中华人民共和国工商行政管理局, 深圳市工商行政管理局, 榆林市工商行政管理局神府经济开发区分局]), (OfficeAddr:LONGTEXT, Examples: [江苏省江阴市利港镇西利路88号]), (SecretaryBDTel:LONGTEXT, Examples: [0510-86632358, 010-67271828, 010-83433677]), (SecuAffairsReprTel:LONGTEXT, Examples: [0510-86632358, 010-83433677, 021-52310063]), (BShareAbbr:LONGTEXT, Examples: [锦江B股]), (HStockCode:LONGTEXT, Examples: [00956, 01033]), (AccountingFirm:LONGTEXT, Examples: [天衡会计师事务所(特殊普通合伙), 普华永道中天会计师事务所(特殊普通合伙), 天职国际会计师事务所(特殊普通合伙)]), (ContactAddr:LONGTEXT, Examples: [江苏省江阴市利港镇西利路88号]), (DisclosurePapers:LONGTEXT, Examples: [《证券时报》《中国证券报》]), (EstablishmentDate:LONGTEXT, Examples: [1995-10-05 12:00:00.000]), (ExtendedAbbr:LONGTEXT, Examples: [派能科技, 睿创微纳, 天能电池集团股份]), (CDRShareAbbr:LONGTEXT), (SecuAffairsRepr:LONGTEXT, Examples: [凌亦奇, 龚亚芳, 于永洪]), (State:BIGINT, Examples: [144200000, 144110000, 144220000]), (SpecialVoteMark:LONGTEXT), (Website:LONGTEXT), (GeneralManager:LONGTEXT, Examples: [刘正宇, 田国涛, 王振东]), (BusinessRegNumber:LONGTEXT, Examples: [320000400001692, 110000002918724, 340200000018594]), (CityCode:BIGINT, Examples: [144200113, 144110119, 144220111]), (SecretaryBDFax:LONGTEXT, Examples: [0510-86630191-481, 010-67271828, 010-83433666]), (UnprofitableMark:LONGTEXT), (AuthReprSBD:LONGTEXT), (RegAddr:LONGTEXT, Examples: [江苏省无锡市江阴市利港镇]), (VIEMark:LONGTEXT), (OfficeZipCode:LONGTEXT, Examples: [214444, 100077, 100089]), (ChiName:LONGTEXT, Examples: [双良节能系统股份有限公司, 国药集团药业股份有限公司, 中公教育科技股份有限公司]), (LegalRepr:LONGTEXT, Examples: [刘正宇, 姜修昌, 王振东]), (Email:LONGTEXT), (SecuAffairsReprFax:LONGTEXT, Examples: [0510-86630191-481, 010-83433666, 021-52310070]), (RegArea:BIGINT, Examples: [144200120, 144110101, 144220114]), (ContactEmail:LONGTEXT), (AStockCode:LONGTEXT, Examples: [600481, 600511, 002607]), (ContactFax:LONGTEXT, Examples: [0510-86630191-481, 010-67271828, 010-83433666]), (XGRQ:LONGTEXT, Examples: [2024-08-30 09:29:07.017]), (BStockCode:LONGTEXT, Examples: [900934]), (CDRStockCode:LONGTEXT), (LegalConsultant:LONGTEXT, Examples: [上海市通力律师事务所, 国浩律师(北京)事务所, 北京市天元律师事务所]) ] # Table: lc_business [ (InduEngaged:LONGTEXT), (XGRQ:LONGTEXT, Examples: [2024-05-17 01:43:13.797]), (InfoPublDate:LONGTEXT, Examples: [2019-01-03 12:00:00.000]), (IfPassed:LONGTEXT, Examples: [0 ]), (MainName:LONGTEXT, Examples: [测试机和分选机等]), (ChangeReason:LONGTEXT), (BusinessMajor:LONGTEXT), (JSID:BIGINT, Examples: [769290274663, 708992057399, 722566190649]), (CompanyCode:BIGINT, Examples: [224275, 1371, 1119]), (SMDeciPublDate:LONGTEXT, Examples: [2019-01-18 12:00:00.000]), (InfoSource:LONGTEXT, Examples: [第二届董事会第八次会议决议公告, 修改《公司章程》的公告, 变更公司章程重要条款获批的公告]), (ID:BIGINT, Primary Key, Examples: [599777135022, 600203406893, 600456797845]), (MainBusiness:LONGTEXT), (IndustryType:BIGINT, Examples: [22]), (BusinessMinor:LONGTEXT, Examples: [液压、锻件、换热器及燃气轮机技术开发、转让、咨询服务、物流、机械冷热加工、修理修配服务。]), (CSRCInduCategory:BIGINT, Examples: [13035, 13032, 20067]) ] 【问题】 查询顺络电子的服务范围记录
Replace text in [BRACKETS] with your own values before pasting.