AiPromptss
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.