tmnam20/text2sql-demo

1context,question2"CREATE TABLE customer (id number, name text, gender text, age number, district_id number;3CREATE TABLE registration (customer_id number, product_id number); 4CREATE TABLE district (id number, name text, prefix text, province_id number); 5CREATE TABLE province (id number, name text, code text)6CREATE TABLE product (id number, category text, name text, description text, price number, duration number, data_amount number, voice_amount number, sms_amount number);",Số lượng khách hàng có độ tuổi từ 15 đến 20 tuổi7"CREATE TABLE customer (id number, name text, gender text, age number, district_id number;8CREATE TABLE registration (customer_id number, product_id number); 9CREATE TABLE district (id number, name text, prefix text, province_id number); 10CREATE TABLE province (id number, name text, code text)11CREATE TABLE product (id number, category text, name text, description text, price number, duration number, data_amount number, voice_amount number, sms_amount number);",Có bao nhiêu khách hàng sử dụng gói cước có tên ST70?12"CREATE TABLE customer (id number, name text, gender text, age number, district_id number;13CREATE TABLE registration (customer_id number, product_id number); 14CREATE TABLE district (id number, name text, prefix text, province_id number); 15CREATE TABLE province (id number, name text, code text)16CREATE TABLE product (id number, category text, name text, description text, price number, duration number, data_amount number, voice_amount number, sms_amount number);",Liệt kê số khách hàng của từng tỉnh17"CREATE TABLE customer (id number, name text, gender text, age number, district_id number;18CREATE TABLE registration (customer_id number, product_id number); 19CREATE TABLE district (id number, name text, prefix text, province_id number); 20CREATE TABLE province (id number, name text, code text)21CREATE TABLE product (id number, category text, name text, description text, price number, duration number, data_amount number, voice_amount number, sms_amount number);22 23product.voice_amount is the call capacity.24product.data_amount is the internet data capacity.25product.sms_amount is the maximum number of sms messages can be sent.","Dung lượng cuộc gọi lớn nhất là bao nhiêu, của sản phẩm nào?"26"CREATE TABLE customer (id number, name text, gender text, age number, district_id number;27CREATE TABLE registration (customer_id number, product_id number); 28CREATE TABLE district (id number, name text, prefix text, province_id number); 29CREATE TABLE province (id number, name text, code text)30CREATE TABLE product (id number, category text, name text, description text, price number, duration number, data_amount number, voice_amount number, sms_amount number);",Sản phẩm ST70 có bao nhiêu lượt đăng kí và sử dụng?31"CREATE TABLE customer (id number, name text, gender text, age number, district_id number;32CREATE TABLE registration (customer_id number, product_id number); 33CREATE TABLE district (id number, name text, prefix text, province_id number); 34CREATE TABLE province (id number, name text, code text)35CREATE TABLE product (id number, category text, name text, description text, price number, duration number, data_amount number, voice_amount number, sms_amount number);",Có bao nhiêu gói cước (sản phẩm) data (category='data')?36"CREATE TABLE customer (id number, name text, gender text, age number, district_id number;37CREATE TABLE registration (customer_id number, product_id number); 38CREATE TABLE district (id number, name text, prefix text, province_id number); 39CREATE TABLE province (id number, name text, code text)40CREATE TABLE product (id number, category text, name text, description text, price number, duration number, data_amount number, voice_amount number, sms_amount number);",Gói cước (sản phẩm nào) có dung lượng internet data lớn nhất?41"CREATE TABLE customer (id number, name text, gender text, age number, district_id number;42CREATE TABLE registration (customer_id number, product_id number); 43CREATE TABLE district (id number, name text, prefix text, province_id number); 44CREATE TABLE province (id number, name text, code text)45CREATE TABLE product (id number, category text, name text, description text, price number, duration number, data_amount number, voice_amount number, sms_amount number);",Có bao nhiêu sản phẩm combo (category='combo') trong hệ thống?