Back to browse
M-Schema
You are now a MySQL data analysis expert. Your task is to write correct SQL queries based on the provided database schema and user questions, and enclose the g…
Added May 19, 20260 views0 copies
Prompt
You are now a MySQL data analysis expert. Your task is to write correct SQL queries based on the provided database schema and user questions, and enclose the generated SQL within ``sql and ```. 【Database 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: [Zhonggong Education, Xin Nuowei, Dayuecheng Holdings]), (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: [Announcement of proposed changes to company name and stock abbreviation]), (ChiName:LONGTEXT, Examples: [Zhonggong Education Technology Co., Ltd., Shiyao Group Xin Nuowei Pharmaceutical Co., Ltd., Dayuecheng Holdings Group Co., Ltd.]), (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: [Xintian Green Energy, Sinopec Oilfield Service]), (AShareAbbr:LONGTEXT, Examples: [Shuangliang Energy, China Medicine, Zhonggong Education]), (SecuAffairsReprEmail:LONGTEXT), (DisclosureWebsites:LONGTEXT), (SecretaryBD:LONGTEXT, Examples: [Yang Likang, Luo Lichun, Wang Xinhua]), (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: [Hydraulics, forgings, castings, heat exchanger technology development, transfer, consulting services, logistics, mechanical cold and hot processing, repair and maintenance services.]), (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: [State Administration for Industry and Commerce of the People's Republic of China, Shenzhen Administration for Industry and Commerce, Yulin Administration for Industry and Commerce Shunfu Economic Development Zone Sub-bureau]), (OfficeAddr:LONGTEXT, Examples: [No. 88 Xili Road, Ligang Town, Jiangyin City, Jiangsu Province]), (SecretaryBDTel:LONGTEXT, Examples: [0510-86632358, 010-67271828, 010-83433677]), (SecuAffairsReprTel:LONGTEXT, Examples: [0510-86632358, 010-83433677, 021-52310063]), (BShareAbbr:LONGTEXT, Examples: [Jinjiang B shares]), (HStockCode:LONGTEXT, Examples: [00956, 01033]), (AccountingFirm:LONGTEXT, Examples: [Tianheng Certified Public Accountants (Special General Partnership), PricewaterhouseCoopers Zhongtian Certified Public Accountants (Special General Partnership), Tianzhi International Certified Public Accountants (Special General Partnership)]), (ContactAddr:LONGTEXT, Examples: [No. 88 Xili Road, Ligang Town, Jiangyin City, Jiangsu Province]), (DisclosurePapers:LONGTEXT, Examples: [Securities Times, China Securities Journal]), (EstablishmentDate:LONGTEXT, Examples: [1995-10-05 12:00:00.000]), (ExtendedAbbr:LONGTEXT, Examples: [Paineng Technology, Ruichuang Micro-Nano, Tianneng Battery Group]), (CDRShareAbbr:LONGTEXT), (SecuAffairsRepr:LONGTEXT, Examples: [Ling Yiqi, Gong Yafang, Yu Yonghong]), (State:BIGINT, Examples: [144200000, 144110000, 144220000]), (SpecialVoteMark:LONGTEXT), (Website:LONGTEXT), (GeneralManager:LONGTEXT, Examples: [Liu Zhengyu, Tian Guotao, Wang Zhendong]), (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: [Ligang Town, Jiangyin City, Wuxi City, Jiangsu Province]), (VIEMark:LONGTEXT), (OfficeZipCode:LONGTEXT, Examples: [214444, 100077, 100089]), (ChiName:LONGTEXT, Examples: [Shuangliang Energy Systems Co., Ltd., China Medicine Group Pharmaceutical Co., Ltd., Zhonggong Education Technology Co., Ltd.]), (LegalRepr:LONGTEXT, Examples: [Liu Zhengyu, Jiang Xiuchang, Wang Zhendong]), (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: [Tongli Law Firm, Guohao Law Firm (Beijing), Tianyuan Law Firm (Beijing)]) ] # 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: [Testing machine and sorting machine, etc.]), (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: [Announcement of resolutions of the eighth meeting of the second board of directors, Announcement of amending the Articles of Association, Announcement of approval of important clauses in the amended Articles of Association]), (ID:BIGINT, Primary Key, Examples: [599777135022, 600203406893, 600456797845]), (MainBusiness:LONGTEXT), (IndustryType:BIGINT, Examples: [22]), (BusinessMinor:LONGTEXT, Examples: [Hydraulics, forgings, heat exchangers and gas turbine technology development, transfer, consulting services, logistics, mechanical cold and hot processing, repair and maintenance services.]), (CSRCInduCategory:BIGINT, Examples: [13035, 13032, 20067]) ] 【Question】 Retrieve the service scope records of Shunluo Electronics ###
Replace text in [BRACKETS] with your own values before pasting.