nl2sqlproj/spider2-nl2sql

1,table_name,ddl,description,insertions,dbms,database,schema,project,dataset20,categories,"CREATE TABLE categories (3    categoryid INTEGER,4    categoryname TEXT,5    description TEXT,6    picture BLOB7);",N/A,"INSERT INTO categories (categoryid, categoryname, description, picture) VALUES (7, 'Produce', 'Dried fruit and bean curd', '\x'), (1, 'Beverages', 'Soft drinks, coffees, teas, beers, and ales', '\x'), (5, 'Grains/Cereals', 'Breads, crackers, pasta, and cereal', '\x'), (8, 'Seafood', 'Seaweed and fish', '\x'), (3, 'Confections', 'Desserts, candies, and sweet breads', '\x');",sqlite,northwind,N/A,N/A,N/A81,customercustomerdemo,"CREATE TABLE customercustomerdemo (9    customerid TEXT,10    customertypeid TEXT11);",N/A,"INSERT INTO customercustomerdemo (customerid, customertypeid) VALUES ;",sqlite,northwind,N/A,N/A,N/A122,usstates,"CREATE TABLE usstates (13    stateid INTEGER,14    statename TEXT,15    stateabbr TEXT,16    stateregion TEXT17);",N/A,"INSERT INTO usstates (stateid, statename, stateabbr, stateregion) VALUES (35, 'North Dakota', 'ND', 'midwest'), (33, 'New York', 'NY', 'east'), (29, 'Nevada', 'NV', 'west'), (37, 'Oklahoma', 'OK', 'midwest'), (51, 'Wyoming', 'WY', 'west');",sqlite,northwind,N/A,N/A,N/A183,orders,"CREATE TABLE orders (19    orderid INTEGER,20    customerid TEXT,21    employeeid INTEGER,22    orderdate DATE,23    requireddate DATE,24    shippeddate DATE,25    shipvia INTEGER,26    freight REAL,27    shipname TEXT,28    shipaddress TEXT,29    shipcity TEXT,30    shipregion TEXT,31    shippostalcode TEXT,32    shipcountry TEXT33);",N/A,"INSERT INTO orders (orderid, customerid, employeeid, orderdate, requireddate, shippeddate, shipvia, freight, shipname, shipaddress, shipcity, shipregion, shippostalcode, shipcountry) VALUES (10799, 'KOENE', 9, '1997-12-26', '1998-02-06', '1998-01-05', 3, 30.7600002, 'Königlich Essen', 'Maubelstr. 90', 'Brandenburg', NULL, '14776', 'Germany'), (11066, 'WHITC', 7, '1998-05-01', '1998-05-29', '1998-05-04', 2, 44.7200012, 'White Clover Markets', '1029 - 12th Ave. S.', 'Seattle', 'WA', '98124', 'USA'), (10920, 'AROUT', 4, '1998-03-03', '1998-03-31', '1998-03-09', 2, 29.6100006, 'Around the Horn', 'Brook Farm Stratford St. Mary', 'Colchester', 'Essex', 'CO7 6JX', 'UK'), (10313, 'QUICK', 2, '1996-09-24', '1996-10-22', '1996-10-04', 2, 1.96000004, 'QUICK-Stop', 'Taucherstraße 10', 'Cunewalde', NULL, '01307', 'Germany'), (10454, 'LAMAI', 4, '1997-02-21', '1997-03-21', '1997-02-25', 3, 2.74000001, 'La maison d''Asie', '1 rue Alsace-Lorraine', 'Toulouse', NULL, '31000', 'France');",sqlite,northwind,N/A,N/A,N/A344,customergroupthreshold,"CREATE TABLE customergroupthreshold (35    groupname TEXT,36    rangebottom DECIMAL,37    rangetop DECIMAL38);",N/A,"INSERT INTO customergroupthreshold (groupname, rangebottom, rangetop) VALUES ('Low', 0, 999.9999), ('Medium', 1000, 4999.9999), ('High', 5000, 9999.9999), ('Very High', 10000, 922337203685477.6);",sqlite,northwind,N/A,N/A,N/A395,customers,"CREATE TABLE customers (40    customerid TEXT,41    companyname TEXT,42    contactname TEXT,43    contacttitle TEXT,44    address TEXT,45    city TEXT,46    region TEXT,47    postalcode TEXT,48    country TEXT,49    phone TEXT,50    fax TEXT51);",N/A,"INSERT INTO customers (customerid, companyname, contactname, contacttitle, address, city, region, postalcode, country, phone, fax) VALUES ('TORTU', 'Tortuga Restaurante', 'Miguel Angel Paolino', 'Owner', 'Avda. Azteca 123', 'México D.F.', NULL, '05033', 'Mexico', '(5) 555-2933', NULL), ('FRANK', 'Frankenversand', 'Peter Franken', 'Marketing Manager', 'Berliner Platz 43', 'München', NULL, '80805', 'Germany', '089-0877310', '089-0877451'), ('GROSR', 'GROSELLA-Restaurante', 'Manuel Pereira', 'Owner', '5ª Ave. Los Palos Grandes', 'Caracas', 'DF', '1081', 'Venezuela', '(2) 283-2951', '(2) 283-3397'), ('NORTS', 'North/South', 'Simon Crowther', 'Sales Associate', 'South House 300 Queensbridge', 'London', NULL, 'SW7 1RZ', 'UK', '(171) 555-7733', '(171) 555-2530'), ('VINET', 'Vins et alcools Chevalier', 'Paul Henriot', 'Accounting Manager', '59 rue de l''Abbaye', 'Reims', NULL, '51100', 'France', '26.47.15.10', '26.47.15.11');",sqlite,northwind,N/A,N/A,N/A526,customerdemographics,"CREATE TABLE customerdemographics (53    customertypeid TEXT,54    customerdesc TEXT55);",N/A,"INSERT INTO customerdemographics (customertypeid, customerdesc) VALUES ;",sqlite,northwind,N/A,N/A,N/A567,order_details,"CREATE TABLE order_details (57    orderid INTEGER,58    productid INTEGER,59    unitprice REAL,60    quantity INTEGER,61    discount REAL62);",N/A,"INSERT INTO order_details (orderid, productid, unitprice, quantity, discount) VALUES (10456, 49, 16.0, 21, 0.150000006), (10671, 16, 17.4500008, 10, 0.0), (10784, 39, 18.0, 2, 0.150000006), (11077, 55, 24.0, 2, 0.0), (10835, 77, 13.0, 2, 0.200000003);",sqlite,northwind,N/A,N/A,N/A638,products,"CREATE TABLE products (64    productid INTEGER,65    productname TEXT,66    supplierid INTEGER,67    categoryid INTEGER,68    quantityperunit TEXT,69    unitprice REAL,70    unitsinstock INTEGER,71    unitsonorder INTEGER,72    reorderlevel INTEGER,73    discontinued INTEGER74);",N/A,"INSERT INTO products (productid, productname, supplierid, categoryid, quantityperunit, unitprice, unitsinstock, unitsonorder, reorderlevel, discontinued) VALUES (59, 'Raclette Courdavault', 28, 4, '5 kg pkg.', 55.0, 79, 0, 0, 0), (16, 'Pavlova', 7, 3, '32 - 500 g boxes', 17.4500008, 29, 0, 10, 0), (52, 'Filo Mix', 24, 5, '16 - 2 kg boxes', 7.0, 38, 0, 25, 0), (53, 'Perth Pasties', 24, 6, '48 pieces', 32.7999992, 0, 0, 0, 1), (74, 'Longlife Tofu', 4, 7, '5 kg pkg.', 10.0, 4, 20, 5, 0);",sqlite,northwind,N/A,N/A,N/A759,employees,"CREATE TABLE employees (76    employeeid INTEGER,77    lastname TEXT,78    firstname TEXT,79    title TEXT,80    titleofcourtesy TEXT,81    birthdate DATE,82    hiredate DATE,83    address TEXT,84    city TEXT,85    region TEXT,86    postalcode TEXT,87    country TEXT,88    homephone TEXT,89    extension TEXT,90    photo BLOB,91    notes TEXT,92    reportsto INTEGER,93    photopath TEXT94);",N/A,"INSERT INTO employees (employeeid, lastname, firstname, title, titleofcourtesy, birthdate, hiredate, address, city, region, postalcode, country, homephone, extension, photo, notes, reportsto, photopath) VALUES (2, 'Fuller', 'Andrew', 'Vice President, Sales', 'Dr.', '1952-02-19', '1992-08-14', '908 W. Capital Way', 'Tacoma', 'WA', '98401', 'USA', '(206) 555-9482', '3457', '\x', 'Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of Dallas in 1981.  He is fluent in French and Italian and reads German.  He joined the company as a sales representative, was promoted to sales manager in January 1992 and to vice president of sales in March 1993.  Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.', nan, 'http://accweb/emmployees/fuller.bmp'), (4, 'Peacock', 'Margaret', 'Sales Representative', 'Mrs.', '1937-09-19', '1993-05-03', '4110 Old Redmond Rd.', 'Redmond', 'WA', '98052', 'USA', '(206) 555-8122', '5176', '\x', 'Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American Institute of Culinary Arts (1966).  She was assigned to the London office temporarily from July through November 1992.', 2.0, 'http://accweb/emmployees/peacock.bmp'), (5, 'Buchanan', 'Steven', 'Sales Manager', 'Mr.', '1955-03-04', '1993-10-17', '14 Garrett Hill', 'London', NULL, 'SW1 8JR', 'UK', '(71) 555-4848', '3453', '\x', 'Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976.  Upon joining the company as a sales representative in 1992, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London.  He was promoted to sales manager in March 1993.  Mr. Buchanan has completed the courses Successful Telemarketing and International Sales Management.  He is fluent in French.', 2.0, 'http://accweb/emmployees/buchanan.bmp'), (3, 'Leverling', 'Janet', 'Sales Representative', 'Ms.', '1963-08-30', '1992-04-01', '722 Moss Bay Blvd.', 'Kirkland', 'WA', '98033', 'USA', '(206) 555-3412', '3355', '\x', 'Janet has a BS degree in chemistry from Boston College (1984).  She has also completed a certificate program in food retailing management.  Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992.', 2.0, 'http://accweb/emmployees/leverling.bmp'), (7, 'King', 'Robert', 'Sales Representative', 'Mr.', '1960-05-29', '1994-01-02', 'Edgeham Hollow\nWinchester Way', 'London', NULL, 'RG1 9SP', 'UK', '(71) 555-5598', '465', '\x', 'Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan in 1992, the year he joined the company.  After completing a course entitled Selling in Europe, he was transferred to the London office in March 1993.', 5.0, 'http://accweb/emmployees/davolio.bmp');",sqlite,northwind,N/A,N/A,N/A9510,shippers,"CREATE TABLE shippers (96    shipperid INTEGER,97    companyname TEXT,98    phone TEXT99);",N/A,"INSERT INTO shippers (shipperid, companyname, phone) VALUES (3, 'Federal Shipping', '(503) 555-9931'), (1, 'Speedy Express', '(503) 555-9831'), (6, 'DHL', '1-800-225-5345'), (5, 'UPS', '1-800-782-7892'), (2, 'United Package', '(503) 555-3199');",sqlite,northwind,N/A,N/A,N/A10011,region,"CREATE TABLE region (101    regionid INTEGER,102    regiondescription TEXT103);",N/A,"INSERT INTO region (regionid, regiondescription) VALUES (1, 'Eastern'), (2, 'Western'), (3, 'Northern'), (4, 'Southern');",sqlite,northwind,N/A,N/A,N/A10412,territories,"CREATE TABLE territories (105    territoryid TEXT,106    territorydescription TEXT,107    regionid INTEGER108);",N/A,"INSERT INTO territories (territoryid, territorydescription, regionid) VALUES ('44122', 'Beachwood', 3), ('14450', 'Fairport', 1), ('98104', 'Seattle', 2), ('95060', 'Santa Cruz', 2), ('60179', 'Hoffman Estates', 2);",sqlite,northwind,N/A,N/A,N/A10913,suppliers,"CREATE TABLE suppliers (110    supplierid INTEGER,111    companyname TEXT,112    contactname TEXT,113    contacttitle TEXT,114    address TEXT,115    city TEXT,116    region TEXT,117    postalcode TEXT,118    country TEXT,119    phone TEXT,120    fax TEXT,121    homepage TEXT122);",N/A,"INSERT INTO suppliers (supplierid, companyname, contactname, contacttitle, address, city, region, postalcode, country, phone, fax, homepage) VALUES (24, 'G''day, Mate', 'Wendy Mackenzie', 'Sales Representative', '170 Prince Edward Parade Hunter''s Hill', 'Sydney', 'NSW', '2042', 'Australia', '(02) 555-5914', '(02) 555-4873', 'G''day Mate (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/gdaymate.htm#'), (9, 'PB Knäckebröd AB', 'Lars Peterson', 'Sales Agent', 'Kaloadagatan 13', 'Göteborg', NULL, 'S-345 67', 'Sweden', '031-987 65 43', '031-987 65 91', NULL), (13, 'Nord-Ost-Fisch Handelsgesellschaft mbH', 'Sven Petersen', 'Coordinator Foreign Markets', 'Frahmredder 112a', 'Cuxhaven', NULL, '27478', 'Germany', '(04721) 8713', '(04721) 8714', NULL), (25, 'Ma Maison', 'Jean-Guy Lauzon', 'Marketing Manager', '2960 Rue St. Laurent', 'Montréal', 'Québec', 'H1J 1C3', 'Canada', '(514) 555-9022', NULL, NULL), (15, 'Norske Meierier', 'Beate Vileid', 'Marketing Manager', 'Hatlevegen 5', 'Sandvika', NULL, '1320', 'Norway', '(0)2-953010', NULL, NULL);",sqlite,northwind,N/A,N/A,N/A12314,employeeterritories,"CREATE TABLE employeeterritories (124    employeeid INTEGER,125    territoryid TEXT126);",N/A,"INSERT INTO employeeterritories (employeeid, territoryid) VALUES (6, '85014'), (3, '30346'), (7, '94025'), (4, '27511'), (7, '95008');",sqlite,northwind,N/A,N/A,N/A12715,shopping_cart_event_identifier,"CREATE TABLE shopping_cart_event_identifier (128    event_type INTEGER,129    event_name TEXT130);",N/A,"INSERT INTO shopping_cart_event_identifier (event_type, event_name) VALUES (3, 'Purchase'), (4, 'Ad Impression'), (1, 'Page View'), (2, 'Add to Cart'), (5, 'Ad Click');",sqlite,bank_sales_trading,N/A,N/A,N/A13116,customer_regions,"CREATE TABLE customer_regions (132    region_id INTEGER,133    region_name TEXT134);",N/A,"INSERT INTO customer_regions (region_id, region_name) VALUES (5, 'Europe'), (3, 'Africa'), (1, 'Australia'), (4, 'Asia'), (2, 'America');",sqlite,bank_sales_trading,N/A,N/A,N/A13517,shopping_cart_page_hierarchy,"CREATE TABLE shopping_cart_page_hierarchy (136    page_id INTEGER,137    page_name TEXT,138    product_category TEXT,139    product_id REAL140);",N/A,"INSERT INTO shopping_cart_page_hierarchy (page_id, page_name, product_category, product_id) VALUES (10, 'Crab', 'Shellfish', 8.0), (8, 'Abalone', 'Shellfish', 6.0), (13, 'Confirmation', NULL, nan), (12, 'Checkout', NULL, nan), (9, 'Lobster', 'Shellfish', 7.0);",sqlite,bank_sales_trading,N/A,N/A,N/A14118,interest_metrics,"CREATE TABLE interest_metrics (142    _month REAL,143    _year REAL,144    month_year TEXT,145    interest_id REAL,146    composition REAL,147    index_value REAL,148    ranking INTEGER,149    percentile_ranking REAL150);",N/A,"INSERT INTO interest_metrics (_month, _year, month_year, interest_id, composition, index_value, ranking, percentile_ranking) VALUES (10.0, 2018.0, '10-2018', 36872.0, 2.79, 1.16, 669, 21.94), (4.0, 2019.0, '04-2019', 38358.0, 1.62, 0.84, 1051, 4.37), (11.0, 2018.0, '11-2018', 34086.0, 1.99, 1.27, 602, 35.13), (11.0, 2018.0, '11-2018', 5.0, 3.67, 1.52, 323, 65.19), (8.0, 2018.0, '08-2018', 28.0, 5.45, 1.46, 228, 70.27);",sqlite,bank_sales_trading,N/A,N/A,N/A15119,interest_map,"CREATE TABLE interest_map (152    id INTEGER,153    interest_name TEXT,154    interest_summary TEXT,155    created_at TEXT,156    last_modified TEXT157);",N/A,"INSERT INTO interest_map (id, interest_name, interest_summary, created_at, last_modified) VALUES (6013, 'Competitive Sports Participants', 'People registering for competitive sports leagues, races, and events for adults.', '2017-03-27 16:36:07', '2019-01-16 09:11:30'), (33959, 'Boston Bruins Fans', 'People reading news about the Boston Bruins and watching games. These consumers are more likely to spend money on team gear.', '2018-08-02 16:05:03', '2018-08-02 16:05:03'), (5, 'Brides & Wedding Planners', 'People researching wedding ideas and vendors.', '2016-05-26 14:57:59', '2018-05-23 11:30:12'), (34635, 'Arizona Cardinals Fans', 'People reading news about the Arizona Cardinals and watching games. These consumers are more likely to spend money on team gear.', '2018-08-20 11:00:03', '2018-08-20 11:00:03'), (6300, 'Washington DC Trip Planners', 'People researching attractions and accommodations in Washington DC. These consumers are more likely to spend money on flights, hotels, and local attractions.', '2017-05-03 10:00:02', '2017-12-07 12:35:47');",sqlite,bank_sales_trading,N/A,N/A,N/A15820,shopping_cart_users,"CREATE TABLE shopping_cart_users (159    user_id INTEGER,160    cookie_id TEXT,161    start_date TEXT162);",N/A,"INSERT INTO shopping_cart_users (user_id, cookie_id, start_date) VALUES (349, '2632eb', '2020-02-01'), (304, '37bc2f', '2020-01-19'), (264, 'e3fc3a', '2020-03-05'), (260, '3d83d3', '2020-03-02'), (146, '2bae8b', '2020-01-16');",sqlite,bank_sales_trading,N/A,N/A,N/A16321,customer_nodes,"CREATE TABLE customer_nodes (164    customer_id INTEGER,165    region_id INTEGER,166    node_id INTEGER,167    start_date TEXT,168    end_date TEXT169);",N/A,"INSERT INTO customer_nodes (customer_id, region_id, node_id, start_date, end_date) VALUES (74, 5, 4, '2020-03-09', '2020-03-21'), (250, 3, 2, '2020-03-21', '2020-03-21'), (281, 2, 1, '2020-03-25', '2020-04-09'), (268, 4, 1, '2020-01-13', '2020-01-16'), (161, 1, 1, '2020-02-12', '2020-03-10');",sqlite,bank_sales_trading,N/A,N/A,N/A17022,veg_cat,"CREATE TABLE veg_cat (171    index INTEGER,172    item_code INTEGER,173    item_name TEXT,174    category_code INTEGER,175    category_name TEXT176);",N/A,"INSERT INTO veg_cat (index, item_code, item_name, category_code, category_name) VALUES (70, 102900011032480, 'Artemisia Stelleriana', 1011010101, 'Flower/Leaf Vegetables'), (172, 102900011032367, 'Red Bell Pepper (2)', 1011010504, 'Capsicum'), (151, 102900011027479, 'Xiaozhoupi', 1011010504, 'Capsicum'), (233, 102900011036266, 'Velvet Antler Mushroom (Box)', 1011010801, 'Edible Mushroom'), (47, 102900011021644, 'Hongshan Caitai', 1011010101, 'Flower/Leaf Vegetables');",sqlite,bank_sales_trading,N/A,N/A,N/A17723,veg_whsle_df,"CREATE TABLE veg_whsle_df (178    index INTEGER,179    whsle_date TEXT,180    item_code INTEGER,181    whsle_px_rmb-kg REAL182);",N/A,"INSERT INTO veg_whsle_df (index, whsle_date, item_code, whsle_px_rmb-kg) VALUES (37193, '2022-06-25 00:00:00', 102900005116547, 4.21), (15704, '2021-06-11 00:00:00', 102900005116509, 1.19), (1255, '2020-08-03 00:00:00', 102900011001806, 3.34), (14012, '2021-05-06 00:00:00', 102900005116547, 3.04), (35253, '2022-05-18 00:00:00', 102900005116714, 5.96);",sqlite,bank_sales_trading,N/A,N/A,N/A18324,bitcoin_members,"CREATE TABLE bitcoin_members (184    member_id TEXT,185    first_name TEXT,186    region TEXT187);",N/A,"INSERT INTO bitcoin_members (member_id, first_name, region) VALUES ('d3d944', 'Enoch', 'Africa'), ('167909', 'Ayush', 'United States'), ('a87ff6', 'Nandita', 'United States'), ('6512bd', 'Vikram', 'India'), ('eccbc8', 'Charlie', 'United States');",sqlite,bank_sales_trading,N/A,N/A,N/A18825,veg_txn_df,"CREATE TABLE veg_txn_df (189    index INTEGER,190    txn_date TEXT,191    txn_time TEXT,192    item_code INTEGER,193    qty_sold(kg) REAL,194    unit_selling_px_rmb/kg REAL,195    sale/return TEXT,196    discount(%) INTEGER,197    day_of_week TEXT198);",N/A,"INSERT INTO veg_txn_df (index, txn_date, txn_time, item_code, qty_sold(kg), unit_selling_px_rmb/kg, sale/return, discount(%), day_of_week) VALUES (231837, '2021-02-14 00:00:00', '18:00:29', 102900051010455, 0.739, 8.0, 'sale', 1, 'Sunday'), (232204, '2021-02-15 00:00:00', '10:10:27', 102900005116912, 0.25, 18.0, 'sale', 1, 'Monday'), (200782, '2021-01-17 00:00:00', '16:19:33', 102900005116547, 0.426, 8.0, 'sale', 1, 'Sunday'), (413284, '2021-09-11 00:00:00', '09:24:48', 102900005115779, 0.389, 8.0, 'sale', 1, 'Saturday'), (584573, '2022-06-16 00:00:00', '13:52:28', 102900011016701, 0.601, 3.2, 'sale', 1, 'Thursday');",sqlite,bank_sales_trading,N/A,N/A,N/A19926,weekly_sales,"CREATE TABLE weekly_sales (200    week_date TEXT,201    region TEXT,202    platform TEXT,203    segment TEXT,204    customer_type TEXT,205    transactions INTEGER,206    sales INTEGER207);",N/A,"INSERT INTO weekly_sales (week_date, region, platform, segment, customer_type, transactions, sales) VALUES ('23/4/18', 'CANADA', 'Retail', NULL, 'Guest', 452234, 12112894), ('1/7/19', 'CANADA', 'Retail', NULL, 'Existing', 6952, 338550), ('2/7/18', 'EUROPE', 'Retail', 'C4', 'Existing', 4584, 263286), ('18/5/20', 'OCEANIA', 'Retail', 'F1', 'Existing', 152103, 7531190), ('29/4/19', 'ASIA', 'Retail', 'F2', 'New', 66571, 2228486);",sqlite,bank_sales_trading,N/A,N/A,N/A20827,customer_transactions,"CREATE TABLE customer_transactions (209    customer_id INTEGER,210    txn_date TEXT,211    txn_type TEXT,212    txn_amount INTEGER213);",N/A,"INSERT INTO customer_transactions (customer_id, txn_date, txn_type, txn_amount) VALUES (204, '2020-04-04', 'deposit', 306), (208, '2020-02-04', 'purchase', 131), (169, '2020-03-15', 'withdrawal', 3), (393, '2020-03-05', 'deposit', 867), (351, '2020-01-12', 'purchase', 583);",sqlite,bank_sales_trading,N/A,N/A,N/A21428,shopping_cart_campaign_identifier,"CREATE TABLE shopping_cart_campaign_identifier (215    campaign_id INTEGER,216    products TEXT,217    campaign_name TEXT,218    start_date TEXT,219    end_date TEXT220);",N/A,"INSERT INTO shopping_cart_campaign_identifier (campaign_id, products, campaign_name, start_date, end_date) VALUES (1, '1-3', 'BOGOF - Fishing For Compliments', '2020-01-01', '2020-01-14'), (2, '4-5', '25% Off - Living The Lux Life', '2020-01-15', '2020-01-28'), (3, '6-8', 'Half Off - Treat Your Shellf(ish)', '2020-02-01', '2020-03-31');",sqlite,bank_sales_trading,N/A,N/A,N/A22129,veg_loss_rate_df,"CREATE TABLE veg_loss_rate_df (222    index INTEGER,223    item_code INTEGER,224    item_name TEXT,225    loss_rate_% REAL226);",N/A,"INSERT INTO veg_loss_rate_df (index, item_code, item_name, loss_rate_%) VALUES (23, 102900005116233, 'Red Pepper (1)', 11.76), (178, 102900011032732, 'High Melon (2)', 9.43), (26, 102900005116530, 'Xixia Mushroom (1)', 13.82), (221, 102900011036242, 'Green And Red Jian Pepper Mix (Bag)', 9.43), (83, 102900011009246, 'Fresh Black Fungus (1)', 7.63);",sqlite,bank_sales_trading,N/A,N/A,N/A22730,bitcoin_prices,"CREATE TABLE bitcoin_prices (228    ticker TEXT,229    market_date TEXT,230    price REAL,231    open REAL,232    high REAL,233    low REAL,234    volume TEXT,235    change TEXT236);",N/A,"INSERT INTO bitcoin_prices (ticker, market_date, price, open, high, low, volume, change) VALUES ('BTC', '10-04-2020', 6863.1, 7289.0, 7294.4, 6756.1, '1.37M', '-5.84%'), ('BTC', '17-11-2019', 8509.8, 8497.4, 8631.7, 8413.0, '531.22K', '0.15%'), ('ETH', '22-09-2018', 240.82, 247.92, 254.36, 233.46, '5.16M', '-2.86%'), ('ETH', '29-01-2019', 104.79, 105.82, 107.32, 102.89, '5.41M', '-0.98%'), ('ETH', '03-09-2020', 381.97, 439.14, 466.4, 376.99, '33.59M', '-13.01%');",sqlite,bank_sales_trading,N/A,N/A,N/A23731,bitcoin_transactions,"CREATE TABLE bitcoin_transactions (238    txn_id INTEGER,239    member_id TEXT,240    ticker TEXT,241    txn_date TEXT,242    txn_type TEXT,243    quantity REAL,244    percentage_fee REAL,245    txn_time TEXT246);",N/A,"INSERT INTO bitcoin_transactions (txn_id, member_id, ticker, txn_date, txn_type, quantity, percentage_fee, txn_time) VALUES (7924, '45c48c', 'BTC', '13-08-2018', 'BUY', 7.595667811, 0.3, '2018-08-13T17:06:25.084Z'), (20253, 'e4da3b', 'BTC', '11-02-2021', 'BUY', 3.011469069, 0.3, '2021-02-11T13:55:41.993Z'), (22460, '6512bd', 'ETH', '22-07-2021', 'SELL', 9.439229697, 0.3, '2021-07-22T21:16:18.459Z'), (4332, 'c51ce4', 'BTC', '18-11-2017', 'BUY', 3.313783888, 0.3, '2017-11-18T12:47:32.767Z'), (3716, 'd3d944', 'BTC', '02-10-2017', 'BUY', 7.151083123, 0.3, '2017-10-02T17:33:44.658Z');",sqlite,bank_sales_trading,N/A,N/A,N/A24732,cleaned_weekly_sales,"CREATE TABLE cleaned_weekly_sales (248    week_date_formatted TEXT,249    week_date TEXT,250    region TEXT,251    platform TEXT,252    segment TEXT,253    customer_type TEXT,254    transactions INTEGER,255    sales INTEGER,256    week_number INTEGER,257    month_number INTEGER,258    calendar_year INTEGER,259    age_band TEXT,260    demographic TEXT,261    avg_transaction REAL262);",N/A,"INSERT INTO cleaned_weekly_sales (week_date_formatted, week_date, region, platform, segment, customer_type, transactions, sales, week_number, month_number, calendar_year, age_band, demographic, avg_transaction) VALUES ('2020-6-1', '2020-06-01', 'AFRICA', 'Shopify', 'C2', 'Existing', 2747, 462331, 23, 6, 2020, 'Middle Aged', 'Couples', 168.3), ('2020-8-31', '2020-08-31', 'AFRICA', 'Shopify', 'unknown', 'Guest', 5893, 1026838, 36, 8, 2020, 'unknown', 'unknown', 174.25), ('2018-8-20', '2018-08-20', 'CANADA', 'Retail', 'C1', 'Existing', 50773, 2212027, 34, 8, 2018, 'Young Adults', 'Couples', 43.57), ('2019-5-20', '2019-05-20', 'OCEANIA', 'Retail', 'C2', 'New', 91473, 2496378, 21, 5, 2019, 'Middle Aged', 'Couples', 27.29), ('2020-7-13', '2020-07-13', 'SOUTH AMERICA', 'Retail', 'F3', 'New', 273, 9451, 29, 7, 2020, 'Retirees', 'Families', 34.62);",sqlite,bank_sales_trading,N/A,N/A,N/A26333,shopping_cart_events,"CREATE TABLE shopping_cart_events (264    visit_id TEXT,265    cookie_id TEXT,266    page_id INTEGER,267    event_type INTEGER,268    sequence_number INTEGER,269    event_time TEXT270);",N/A,"INSERT INTO shopping_cart_events (visit_id, cookie_id, page_id, event_type, sequence_number, event_time) VALUES ('71740f', 'b6d767', 4, 1, 3, '2020-02-08 21:32:06.252986'), ('33e1af', '322fd1', 1, 1, 1, '2020-02-28 18:45:33.90196'), ('eaffde', '14de71', 13, 3, 21, '2020-03-25 20:17:12.484998'), ('4d2d07', '75260d', 3, 1, 3, '2020-02-17 01:08:10.966062'), ('da7cf0', '28dd2c', 4, 2, 7, '2020-01-14 05:06:29.911936');",sqlite,bank_sales_trading,N/A,N/A,N/A27134,Employee,"CREATE TABLE Employee (272    EmployeeId INTEGER,273    LastName NVARCHAR(20),274    FirstName NVARCHAR(20),275    Title NVARCHAR(30),276    ReportsTo INTEGER,277    BirthDate DATETIME,278    HireDate DATETIME,279    Address NVARCHAR(70),280    City NVARCHAR(40),281    State NVARCHAR(40),282    Country NVARCHAR(40),283    PostalCode NVARCHAR(10),284    Phone NVARCHAR(24),285    Fax NVARCHAR(24),286    Email NVARCHAR(60)287);",N/A,"INSERT INTO Employee (EmployeeId, LastName, FirstName, Title, ReportsTo, BirthDate, HireDate, Address, City, State, Country, PostalCode, Phone, Fax, Email) VALUES (1, 'Adams', 'Andrew', 'General Manager', nan, '1962-02-18 00:00:00', '2002-08-14 00:00:00', '11120 Jasper Ave NW', 'Edmonton', 'AB', 'Canada', 'T5K 2N1', '+1 (780) 428-9482', '+1 (780) 428-3457', 'andrew@chinookcorp.com'), (6, 'Mitchell', 'Michael', 'IT Manager', 1.0, '1973-07-01 00:00:00', '2003-10-17 00:00:00', '5827 Bowness Road NW', 'Calgary', 'AB', 'Canada', 'T3B 0C5', '+1 (403) 246-9887', '+1 (403) 246-9899', 'michael@chinookcorp.com'), (7, 'King', 'Robert', 'IT Staff', 6.0, '1970-05-29 00:00:00', '2004-01-02 00:00:00', '590 Columbia Boulevard West', 'Lethbridge', 'AB', 'Canada', 'T1K 5N8', '+1 (403) 456-9986', '+1 (403) 456-8485', 'robert@chinookcorp.com'), (5, 'Johnson', 'Steve', 'Sales Support Agent', 2.0, '1965-03-03 00:00:00', '2003-10-17 00:00:00', '7727B 41 Ave', 'Calgary', 'AB', 'Canada', 'T3B 1Y7', '1 (780) 836-9987', '1 (780) 836-9543', 'steve@chinookcorp.com'), (8, 'Callahan', 'Laura', 'IT Staff', 6.0, '1968-01-09 00:00:00', '2004-03-04 00:00:00', '923 7 ST NW', 'Lethbridge', 'AB', 'Canada', 'T1H 1Y8', '+1 (403) 467-3351', '+1 (403) 467-8772', 'laura@chinookcorp.com');",sqlite,music,N/A,N/A,N/A28835,InvoiceLine,"CREATE TABLE InvoiceLine (289    InvoiceLineId INTEGER,290    InvoiceId INTEGER,291    TrackId INTEGER,292    UnitPrice NUMERIC(10,2),293    Quantity INTEGER294);",N/A,"INSERT INTO InvoiceLine (InvoiceLineId, InvoiceId, TrackId, UnitPrice, Quantity) VALUES (752, 138, 1076, 0.99, 1), (1883, 347, 949, 0.99, 1), (2114, 390, 2368, 0.99, 1), (136, 26, 795, 0.99, 1), (941, 173, 2227, 0.99, 1);",sqlite,music,N/A,N/A,N/A29536,Playlist,"CREATE TABLE Playlist (296    PlaylistId INTEGER,297    Name NVARCHAR(120)298);",N/A,"INSERT INTO Playlist (PlaylistId, Name) VALUES (16, 'Grunge'), (7, 'Movies'), (4, 'Audiobooks'), (6, 'Audiobooks'), (15, 'Classical 101 - The Basics');",sqlite,music,N/A,N/A,N/A29937,Genre,"CREATE TABLE Genre (300    GenreId INTEGER,301    Name NVARCHAR(120)302);",N/A,"INSERT INTO Genre (GenreId, Name) VALUES (14, 'R&B/Soul'), (22, 'Comedy'), (16, 'World'), (21, 'Drama'), (2, 'Jazz');",sqlite,music,N/A,N/A,N/A30338,Artist,"CREATE TABLE Artist (304    ArtistId INTEGER,305    Name NVARCHAR(120)306);",N/A,"INSERT INTO Artist (ArtistId, Name) VALUES (232, 'Sergei Prokofiev & Yuri Temirkanov'), (73, 'Vinícius E Qurteto Em Cy'), (114, 'Ozzy Osbourne'), (166, 'Avril Lavigne'), (134, 'Stone Temple Pilots');",sqlite,music,N/A,N/A,N/A30739,MediaType,"CREATE TABLE MediaType (308    MediaTypeId INTEGER,309    Name NVARCHAR(120)310);",N/A,"INSERT INTO MediaType (MediaTypeId, Name) VALUES (1, 'MPEG audio file'), (5, 'AAC audio file'), (4, 'Purchased AAC audio file'), (2, 'Protected AAC audio file'), (3, 'Protected MPEG-4 video file');",sqlite,music,N/A,N/A,N/A31140,Invoice,"CREATE TABLE Invoice (312    InvoiceId INTEGER,313    CustomerId INTEGER,314    InvoiceDate DATETIME,315    BillingAddress NVARCHAR(70),316    BillingCity NVARCHAR(40),317    BillingState NVARCHAR(40),318    BillingCountry NVARCHAR(40),319    BillingPostalCode NVARCHAR(10),320    Total NUMERIC(10,2)321);",N/A,"INSERT INTO Invoice (InvoiceId, CustomerId, InvoiceDate, BillingAddress, BillingCity, BillingState, BillingCountry, BillingPostalCode, Total) VALUES (175, 6, '2011-02-15 00:00:00', 'Rilská 3174/6', 'Prague', NULL, 'Czech Republic', '14300', 1.98), (323, 39, '2012-11-27 00:00:00', '4, Rue Milton', 'Paris', NULL, 'France', '75009', 1.98), (385, 25, '2013-09-02 00:00:00', '319 N. Frances Street', 'Madison', 'WI', 'USA', '53703', 1.98), (290, 32, '2012-06-27 00:00:00', '696 Osborne Street', 'Winnipeg', 'MB', 'Canada', 'R3L 2B9', 5.94), (348, 56, '2013-03-10 00:00:00', '307 Macacha Güemes', 'Buenos Aires', NULL, 'Argentina', '1106', 13.86);",sqlite,music,N/A,N/A,N/A32241,Album,"CREATE TABLE Album (323    AlbumId INTEGER,324    Title NVARCHAR(160),325    ArtistId INTEGER326);",N/A,"INSERT INTO Album (AlbumId, Title, ArtistId) VALUES (296, 'A Copland Celebration, Vol. I', 230), (2, 'Balls to the Wall', 2), (70, 'Djavan Ao Vivo - Vol. 1', 80), (136, 'Presence', 22), (294, 'Great Performances - Barber''s Adagio and Other Romantic Favorites for Strings', 228);",sqlite,music,N/A,N/A,N/A32742,Customer,"CREATE TABLE Customer (328    CustomerId INTEGER,329    FirstName NVARCHAR(40),330    LastName NVARCHAR(20),331    Company NVARCHAR(80),332    Address NVARCHAR(70),333    City NVARCHAR(40),334    State NVARCHAR(40),335    Country NVARCHAR(40),336    PostalCode NVARCHAR(10),337    Phone NVARCHAR(24),338    Fax NVARCHAR(24),339    Email NVARCHAR(60),340    SupportRepId INTEGER341);",N/A,"INSERT INTO Customer (CustomerId, FirstName, LastName, Company, Address, City, State, Country, PostalCode, Phone, Fax, Email, SupportRepId) VALUES (34, 'João', 'Fernandes', NULL, 'Rua da Assunção 53', 'Lisbon', NULL, 'Portugal', NULL, '+351 (213) 466-111', NULL, 'jfernandes@yahoo.pt', 4), (1, 'Luís', 'Gonçalves', 'Embraer - Empresa Brasileira de Aeronáutica S.A.', 'Av. Brigadeiro Faria Lima, 2170', 'São José dos Campos', 'SP', 'Brazil', '12227-000', '+55 (12) 3923-5555', '+55 (12) 3923-5566', 'luisg@embraer.com.br', 3), (21, 'Kathy', 'Chase', NULL, '801 W 4th Street', 'Reno', 'NV', 'USA', '89503', '+1 (775) 223-7665', NULL, 'kachase@hotmail.com', 5), (54, 'Steve', 'Murray', NULL, '110 Raeburn Pl', 'Edinburgh ', NULL, 'United Kingdom', 'EH4 1HH', '+44 0131 315 3300', NULL, 'steve.murray@yahoo.uk', 5), (41, 'Marc', 'Dubois', NULL, '11, Place Bellecour', 'Lyon', NULL, 'France', '69002', '+33 04 78 30 30 30', NULL, 'marc.dubois@hotmail.com', 5);",sqlite,music,N/A,N/A,N/A34243,Track,"CREATE TABLE Track (343    TrackId INTEGER,344    Name NVARCHAR(200),345    AlbumId INTEGER,346    MediaTypeId INTEGER,347    GenreId INTEGER,348    Composer NVARCHAR(220),349    Milliseconds INTEGER,350    Bytes INTEGER,351    UnitPrice NUMERIC(10,2)352);",N/A,"INSERT INTO Track (TrackId, Name, AlbumId, MediaTypeId, GenreId, Composer, Milliseconds, Bytes, UnitPrice) VALUES (462, 'Valentino''s', 38, 1, 2, NULL, 296124, 9848545, 0.99), (281, 'Computadores Fazem Arte', 25, 1, 7, NULL, 404323, 13702771, 0.99), (2846, 'Seven Minutes to Midnight', 228, 3, 21, NULL, 2613988, 515590682, 1.99), (3423, 'Jupiter, the Bringer of Jollity', 292, 2, 24, 'Gustav Holst', 522099, 8547876, 0.99), (1044, 'My Kind Of Town', 83, 1, 12, 'jimmy van heusen/sammy cahn', 188499, 6119915, 0.99);",sqlite,music,N/A,N/A,N/A35344,PlaylistTrack,"CREATE TABLE PlaylistTrack (354    PlaylistId INTEGER,355    TrackId INTEGER356);",N/A,"INSERT INTO PlaylistTrack (PlaylistId, TrackId) VALUES (1, 1649), (8, 2186), (1, 1661), (5, 2686), (1, 1958);",sqlite,music,N/A,N/A,N/A35745,deliveries,"CREATE TABLE deliveries (358    delivery_id INTEGER,359    delivery_order_id INTEGER,360    driver_id INTEGER,361    delivery_distance_meters DECIMAL(10, 2),362    delivery_status VARCHAR(50)363);",N/A,"INSERT INTO deliveries (delivery_id, delivery_order_id, driver_id, delivery_distance_meters, delivery_status) VALUES (2846666, 87624407, 50626, 1299, 'DELIVERED'), (2969242, 90569745, 17322, 3387, 'DELIVERED'), (2954475, 90177159, 11166, 3431, 'DELIVERED'), (2560464, 81068903, 36132, 652, 'DELIVERED'), (2973175, 90621386, 5574, 1617, 'DELIVERED');",sqlite,delivery_center,N/A,N/A,N/A36446,orders,"CREATE TABLE orders (365    order_id INTEGER,366    store_id INTEGER,367    channel_id INTEGER,368    payment_order_id INTEGER,369    delivery_order_id INTEGER,370    order_status VARCHAR(50),371    order_amount DECIMAL(10, 2),372    order_delivery_fee DECIMAL(10, 2),373    order_delivery_cost DECIMAL(10, 2),374    order_created_hour INTEGER,375    order_created_minute INTEGER,376    order_created_day INTEGER,377    order_created_month INTEGER,378    order_created_year INTEGER,379    order_moment_created DATETIME,380    order_moment_accepted DATETIME,381    order_moment_ready DATETIME,382    order_moment_collected DATETIME,383    order_moment_in_expedition DATETIME,384    order_moment_delivering DATETIME,385    order_moment_delivered DATETIME,386    order_moment_finished DATETIME,387    order_metric_collected_time DECIMAL(10, 2),388    order_metric_paused_time DECIMAL(10, 2),389    order_metric_production_time DECIMAL(10, 2),390    order_metric_walking_time DECIMAL(10, 2),391    order_metric_expediton_speed_time DECIMAL(10, 2),392    order_metric_transit_time DECIMAL(10, 2),393    order_metric_cycle_time DECIMAL(10, 2)394);",N/A,"INSERT INTO orders (order_id, store_id, channel_id, payment_order_id, delivery_order_id, order_status, order_amount, order_delivery_fee, order_delivery_cost, order_created_hour, order_created_minute, order_created_day, order_created_month, order_created_year, order_moment_created, order_moment_accepted, order_moment_ready, order_moment_collected, order_moment_in_expedition, order_moment_delivering, order_moment_delivered, order_moment_finished, order_metric_collected_time, order_metric_paused_time, order_metric_production_time, order_metric_walking_time, order_metric_expediton_speed_time, order_metric_transit_time, order_metric_cycle_time) VALUES (80904697, 149, 5, 80904697, 80904697, 'CANCELED', 199.7, 11.9, 0.0, 22, 20, 1, 3, 2021, '3/1/2021 10:20:24 PM', '3/1/2021 10:21:04 PM', '3/1/2021 10:39:31 PM', '3/1/2021 10:40:43 PM', '3/1/2021 10:43:26 PM', NULL, NULL, NULL, 1.2, nan, 19.12, 3.92, nan, nan, nan), (79002206, 2812, 5, 79002206, 79002206, 'FINISHED', 40.9, 3.99, 6.0, 16, 56, 20, 2, 2021, '2/20/2021 4:56:06 PM', '2/20/2021 4:56:37 PM', '2/20/2021 5:02:30 PM', '2/20/2021 5:04:29 PM', '2/20/2021 5:04:30 PM', '2/20/2021 5:05:24 PM', NULL, '2/20/2021 5:19:46 PM', 1.97, 0.88, 6.4, 2.0, 2.88, 14.37, 23.67), (86438261, 676, 5, 86438261, 86438261, 'FINISHED', 125.8, 11.9, 7.32, 20, 40, 27, 3, 2021, '3/27/2021 8:40:19 PM', '3/27/2021 8:40:35 PM', '3/27/2021 8:58:59 PM', '3/27/2021 8:59:54 PM', '3/27/2021 8:59:55 PM', '3/27/2021 9:02:29 PM', NULL, '3/27/2021 9:10:47 PM', 0.93, 2.57, 18.67, 0.93, 3.5, 8.3, 30.47), (69121075, 294, 5, 69121075, 69121075, 'FINISHED', 201.2, 6.9, 6.0, 15, 32, 4, 1, 2021, '1/4/2021 3:32:49 PM', '1/4/2021 3:33:03 PM', '1/4/2021 3:52:34 PM', '1/4/2021 3:56:44 PM', '1/4/2021 4:00:08 PM', '1/4/2021 4:01:22 PM', NULL, '1/4/2021 4:16:23 PM', 4.17, 1.23, 19.75, 7.57, 8.8, 15.02, 43.57), (75419211, 690, 5, 75419211, 75419211, 'FINISHED', 49.9, 6.9, 6.0, 15, 5, 3, 2, 2021, '2/3/2021 3:05:27 PM', '2/3/2021 3:06:07 PM', '2/3/2021 3:17:43 PM', '2/3/2021 3:21:39 PM', '2/3/2021 3:25:46 PM', '2/3/2021 3:26:08 PM', NULL, '2/3/2021 3:44:17 PM', 3.93, 0.35, 12.27, 8.05, 8.4, 18.17, 38.85);",sqlite,delivery_center,N/A,N/A,N/A39547,channels,"CREATE TABLE channels (396    channel_id INTEGER,397    channel_name VARCHAR(50),398    channel_type VARCHAR(50)399);",N/A,"INSERT INTO channels (channel_id, channel_name, channel_type) VALUES (48, 'CENTER PLACE', 'MARKETPLACE'), (37, 'LONGO PLACE', 'MARKETPLACE'), (23, 'ATCHIN PLACE', 'MARKETPLACE'), (30, 'SPEED PLACE', 'MARKETPLACE'), (32, 'BEATLES PLACE', 'MARKETPLACE');",sqlite,delivery_center,N/A,N/A,N/A40048,drivers,"CREATE TABLE drivers (401    driver_id INTEGER,402    driver_modal VARCHAR(50),403    driver_type VARCHAR(50)404);",N/A,"INSERT INTO drivers (driver_id, driver_modal, driver_type) VALUES (52706, 'BIKER', 'FREELANCE'), (44347, 'MOTOBOY', 'LOGISTIC OPERATOR'), (9461, 'MOTOBOY', 'FREELANCE'), (16063, 'MOTOBOY', 'FREELANCE'), (28265, 'BIKER', 'FREELANCE');",sqlite,delivery_center,N/A,N/A,N/A40549,payments,"CREATE TABLE payments (406    payment_id INTEGER,407    payment_order_id INTEGER,408    payment_amount DECIMAL(10, 2),409    payment_fee DECIMAL(10, 2),410    payment_method VARCHAR(50),411    payment_status VARCHAR(50)412);",N/A,"INSERT INTO payments (payment_id, payment_order_id, payment_amount, payment_fee, payment_method, payment_status) VALUES (4752837, 78368205, 54.89, 0.82, 'ONLINE', 'PAID'), (5193935, 87731016, 42.94, 0.64, 'ONLINE', 'PAID'), (4720509, 77351048, 122.5, 3.31, 'ONLINE', 'PAID'), (5085045, 85938962, 10.0, 0.0, 'VOUCHER', 'PAID'), (4905032, 82243889, 35.0, 0.46, 'ONLINE', 'PAID');",sqlite,delivery_center,N/A,N/A,N/A41350,hubs,"CREATE TABLE hubs (414    hub_id INTEGER,415    hub_name VARCHAR(50),416    hub_city VARCHAR(50),417    hub_state CHAR(2),418    hub_latitude DECIMAL(9, 6),419    hub_longitude DECIMAL(9, 6)420);",N/A,"INSERT INTO hubs (hub_id, hub_name, hub_city, hub_state, hub_latitude, hub_longitude) VALUES (21, 'WOLF SHOPPING', 'SÃO PAULO', 'SP', -23.550407, -46.6973162), (44, 'FORTRAN SHOPPING', 'CURITIBA', 'PR', -25.4351398, -49.3167883), (75, 'PYTHON SHOPPING', 'CURITIBA', 'PR', -25.477073, -49.28966), (18, 'STAR SHOPPING', 'RIO DE JANEIRO', 'RJ', -22.9454948, -43.1821807), (35, 'BEACH SHOPPING', 'RIO DE JANEIRO', 'RJ', -22.96988, -43.370811);",sqlite,delivery_center,N/A,N/A,N/A42151,stores,"CREATE TABLE stores (422    store_id INTEGER,423    hub_id INTEGER,424    store_name VARCHAR(50),425    store_segment VARCHAR(50),426    store_plan_price DECIMAL(10, 2),427    store_latitude DECIMAL(9, 6),428    store_longitude DECIMAL(9, 6)429);",N/A,"INSERT INTO stores (store_id, hub_id, store_name, store_segment, store_plan_price, store_latitude, store_longitude) VALUES (1603, 29, 'MIOURIOU ', 'GOOD', nan, -23.561053, -46.558976), (4214, 44, 'RCOUMILES ', 'FOOD', nan, -25.4351398, -49.3167883), (3987, 85, 'POI ILARUMUIMOI ', 'FOOD', 49.0, -23.5133533, -46.6183535), (616, 18, 'CILAFIRMAI CIOLA ', 'FOOD', 49.0, -22.94733, -43.183534), (674, 29, 'AR TRAMUO ', 'FOOD', 49.9, -23.561053, -46.558976);",sqlite,delivery_center,N/A,N/A,N/A43052,aliens,"CREATE TABLE aliens (431    id INTEGER,432    first_name TEXT,433    last_name TEXT,434    email TEXT,435    gender TEXT,436    type TEXT,437    birth_year INTEGER438);",N/A,"INSERT INTO aliens (id, first_name, last_name, email, gender, type, birth_year) VALUES (21003, 'Morton', 'Szymaniak', 'mszymaniakg7e@1688.com', 'Male', 'Nordic', 1822), (27407, 'Diane-marie', 'Chalk', 'dchalkl5a@paginegialle.it', 'Female', 'Flatwoods', 1810), (40469, 'Hagan', 'Connerly', 'hconnerlyv84@umn.edu', 'Male', 'Green', 1864), (22356, 'Tess', 'Bradnick', 'tbradnickh8z@timesonline.co.uk', 'Female', 'Reptile', 1858), (23546, 'Martita', 'Jelfs', 'mjelfsi61@diigo.com', 'Female', 'Grey', 1751);",sqlite,city_legislation,N/A,N/A,N/A43953,aliens_details,"CREATE TABLE aliens_details (440    detail_id INTEGER,441    favorite_food TEXT,442    feeding_frequency TEXT,443    aggressive INTEGER444);",N/A,"INSERT INTO aliens_details (detail_id, favorite_food, feeding_frequency, aggressive) VALUES (10521, 'Wambenger, red-tailed', 'Once', 0), (5319, 'Crab, sally lightfoot', 'Often', 1), (19113, 'Roan antelope', 'Monthly', 0), (33703, 'Gecko, barking', 'Often', 1), (30823, 'Spider, wolf', 'Never', 1);",sqlite,city_legislation,N/A,N/A,N/A44554,skills_dim,"CREATE TABLE skills_dim (446    skill_id INTEGER,447    skills TEXT,448    type TEXT449);",N/A,"INSERT INTO skills_dim (skill_id, skills, type) VALUES (187, 'qlik', 'analyst_tools'), (31, 'perl', 'programming'), (9, 'javascript', 'programming'), (12, 'bash', 'programming'), (50, 'lua', 'programming');",sqlite,city_legislation,N/A,N/A,N/A45055,job_postings_fact,"CREATE TABLE job_postings_fact (451    job_id INTEGER,452    company_id INTEGER,453    job_title_short TEXT,454    job_title TEXT,455    job_location TEXT,456    job_via TEXT,457    job_schedule_type TEXT,458    job_work_from_home INTEGER,459    search_location TEXT,460    job_posted_date TEXT,461    job_no_degree_mention INTEGER,462    job_health_insurance INTEGER,463    job_country TEXT,464    salary_rate TEXT,465    salary_year_avg REAL,466    salary_hour_avg REAL467);",N/A,"INSERT INTO job_postings_fact (job_id, company_id, job_title_short, job_title, job_location, job_via, job_schedule_type, job_work_from_home, search_location, job_posted_date, job_no_degree_mention, job_health_insurance, job_country, salary_rate, salary_year_avg, salary_hour_avg) VALUES (1722126, 94819, 'Data Analyst', 'Supply Chain Data Analytics Manager - Now Hiring', 'Columbia, MD', 'via Snagajob', 'Full-time and Part-time', 0, 'New York, United States', '2023-09-17 07:00:47', 0, 1, 'United States', 'hour', NULL, 23.69499969482422), (1046646, 2438, 'Data Scientist', 'Chief Data Science and Data Engineering Officer, Charleroi', 'Charleroi, Belgium', 'via BeBee Belgique', 'Part-time', 0, 'Belgium', '2023-06-15 16:55:20', 0, 0, 'Belgium', NULL, NULL, nan), (103424, 4473, 'Data Scientist', 'Data Scientist /hybrid/', 'New York, NY', 'via GrabJobs', 'Full-time', 0, 'New York, United States', '2023-11-17 17:02:57', 0, 1, 'United States', NULL, NULL, nan), (967500, 352, 'Software Engineer', 'Integration Engineer', 'Dublin, Ireland', 'via BeBee Ireland', 'Full-time', 0, 'Ireland', '2023-09-25 15:52:26', 1, 0, 'Ireland', NULL, NULL, nan), (884963, 113, 'Software Engineer', 'Full-Stack Python Engineer', 'United Arab Emirates', 'via BeBee', 'Full-time', 0, 'United Arab Emirates', '2023-07-02 09:34:45', 0, 0, 'United Arab Emirates', NULL, NULL, nan);",sqlite,city_legislation,N/A,N/A,N/A46856,job_company,"CREATE TABLE job_company (469    company_id INTEGER,470    name TEXT,471    link TEXT,472    link_google TEXT,473    thumbnail TEXT474);",N/A,"INSERT INTO job_company (company_id, name, link, link_google, thumbnail) VALUES (477107, 'Atom Learning', NULL, 'https://www.google.com/search?ucbcb=1&gl=us&hl=en&q=Atom+Learning&sa=X&ved=0ahUKEwiyhK-9rOL9AhWGPkQIHRkvDk8QmJACCLoJ', NULL), (271209, 'Fidelity Life', NULL, 'https://www.google.com/search?gl=us&hl=en&q=Fidelity+Life&sa=X&ved=0ahUKEwiK96L6-sv-AhXgjLAFHVSUAG0QmJACCLkJ', NULL), (297649, 'Pando Group', NULL, 'https://www.google.com/search?gl=us&hl=en&q=Pando+Group&sa=X&ved=0ahUKEwiEkt6OgNP8AhUMMVkFHbsxAMAQmJACCJ0L', 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcS7pBB1_fLU_5GVPG0wFtsXVDIlna_MbeEJnN9zOQY&s'), (280330, 'RaiceTech Soft', NULL, 'https://www.google.com/search?sca_esv=586505729&hl=en&gl=us&q=RaiceTech+Soft&sa=X&ved=0ahUKEwj0xri5iOuCAxUGEFkFHWM8CIU4KBCYkAIInQw', 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRyTXj8umBy4xThWXztzSQSba6bWqIV3cikNEqsBiI&s'), (542480, 'Arcadis Gen', 'http://www.arcadis.com/', 'https://www.google.com/search?gl=us&hl=en&q=Arcadis+Gen&sa=X&ved=0ahUKEwi_2cfO4KP-AhUzlYkEHURLAGc4jAEQmJACCNIM', NULL);",sqlite,city_legislation,N/A,N/A,N/A47557,cities_currencies,"CREATE TABLE cities_currencies (476    currency_id INTEGER,477    country_code_2 TEXT,478    currency_name TEXT,479    currency_code TEXT480);",N/A,"INSERT INTO cities_currencies (currency_id, country_code_2, currency_name, currency_code) VALUES (197, 'sm', 'euro', 'eur'), (107, 'iq', 'iraqi dinar', 'iqd'), (152, 'me', 'euro', 'eur'), (166, 'ng', 'naira', 'ngn'), (31, 'io', 'us dollar', 'usd');",sqlite,city_legislation,N/A,N/A,N/A48158,legislation_date_dim,"CREATE TABLE legislation_date_dim (482    date TEXT,483    month_name TEXT,484    day_of_month INTEGER485);",N/A,"INSERT INTO legislation_date_dim (date, month_name, day_of_month) VALUES ('1951-06-11', 'June', 11), ('1963-10-28', 'October', 28), ('1989-10-03', 'October', 3), ('1962-09-28', 'September', 28), ('1959-02-12', 'February', 12);",sqlite,city_legislation,N/A,N/A,N/A48659,aliens_location,"CREATE TABLE aliens_location (487    loc_id INTEGER,488    current_location TEXT,489    state TEXT,490    country TEXT,491    occupation TEXT492);",N/A,"INSERT INTO aliens_location (loc_id, current_location, state, country, occupation) VALUES (29529, 'Cleveland', 'Ohio', 'United States', 'Staff Accountant III'), (8670, 'Denver', 'Colorado', 'United States', 'Human Resources Assistant IV'), (16425, 'Erie', 'Pennsylvania', 'United States', 'Junior Executive'), (37693, 'New Orleans', 'Louisiana', 'United States', 'Research Nurse'), (40241, 'Monticello', 'Minnesota', 'United States', 'Automation Specialist II');",sqlite,city_legislation,N/A,N/A,N/A49360,cities_countries,"CREATE TABLE cities_countries (494    country_id INTEGER,495    country_name TEXT,496    country_code_2 TEXT,497    country_code_3 TEXT,498    region TEXT,499    sub_region TEXT,500    intermediate_region TEXT,501    created_on TEXT502);",N/A,"INSERT INTO cities_countries (country_id, country_name, country_code_2, country_code_3, region, sub_region, intermediate_region, created_on) VALUES (115, 'italy', 'it', 'ita', 'europe', 'southern europe', NULL, '2024-07-18'), (7, 'cyprus', 'cy', 'cyp', 'asia', 'western asia', NULL, '2024-07-18'), (195, 'rwanda', 'rw', 'rwa', 'africa', 'subsaharan africa', 'eastern africa', '2024-07-18'), (163, 'nepal', 'np', 'npl', 'asia', 'southern asia', NULL, '2024-07-18'), (224, 'suriname', 'sr', 'sur', 'americas', 'latin america and the caribbean', 'south america', '2024-07-18');",sqlite,city_legislation,N/A,N/A,N/A50361,skills_job_dim,"CREATE TABLE skills_job_dim (504    job_id INTEGER,505    skill_id INTEGER506);",N/A,"INSERT INTO skills_job_dim (job_id, skill_id) VALUES (469920, 199), (298741, 61), (1621230, 183), (500523, 214), (243533, 7);",sqlite,city_legislation,N/A,N/A,N/A50762,cities_languages,"CREATE TABLE cities_languages (508    language_id INTEGER,509    language TEXT,510    country_code_2 TEXT511);",N/A,"INSERT INTO cities_languages (language_id, language, country_code_2) VALUES (5, 'english', 'al'), (410, 'korean', 'kp'), (461, 'english', 'sa'), (542, 'english', 'tw'), (543, 'taroko', 'tw');",sqlite,city_legislation,N/A,N/A,N/A51263,legislators,"CREATE TABLE legislators (513    full_name TEXT,514    first_name TEXT,515    last_name TEXT,516    middle_name TEXT,517    nickname TEXT,518    suffix TEXT,519    other_names_end TEXT,520    other_names_middle REAL,521    other_names_last TEXT,522    birthday TEXT,523    gender TEXT,524    id_bioguide TEXT,525    id_bioguide_previous_0 TEXT,526    id_govtrack INTEGER,527    id_icpsr REAL,528    id_wikipedia TEXT,529    id_wikidata TEXT,530    id_google_entity_id TEXT,531    id_house_history REAL,532    id_house_history_alternate REAL,533    id_thomas REAL,534    id_cspan REAL,535    id_votesmart REAL,536    id_lis TEXT,537    id_ballotpedia TEXT,538    id_opensecrets TEXT,539    id_fec_0 TEXT,540    id_fec_1 TEXT,541    id_fec_2 TEXT542);",N/A,"INSERT INTO legislators (full_name, first_name, last_name, middle_name, nickname, suffix, other_names_end, other_names_middle, other_names_last, birthday, gender, id_bioguide, id_bioguide_previous_0, id_govtrack, id_icpsr, id_wikipedia, id_wikidata, id_google_entity_id, id_house_history, id_house_history_alternate, id_thomas, id_cspan, id_votesmart, id_lis, id_ballotpedia, id_opensecrets, id_fec_0, id_fec_1, id_fec_2) VALUES ('Thomas Francis Burchill', 'Thomas', 'Burchill', 'Francis', NULL, NULL, NULL, NULL, NULL, '1882-08-03', 'M', 'B001072', NULL, 402018, 1248.0, 'Thomas F. Burchill', 'Q3332131', 'kg:/m/026fp3p', 10157.0, NULL, nan, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), ('Henry Gray Turner', 'Henry', 'Turner', 'Gray', NULL, NULL, NULL, NULL, NULL, '1839-03-20', 'M', 'T000421', NULL, 410990, 9516.0, 'Henry Gray Turner', 'Q1606804', 'kg:/m/026j32c', 23150.0, NULL, nan, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), ('Jotham Post', 'Jotham', 'Post', NULL, NULL, 'Jr.', NULL, NULL, NULL, '1771-04-04', 'M', 'P000455', NULL, 408842, 7546.0, 'Jotham Post Jr.', 'Q168616', 'kg:/m/02rktbn', 19845.0, NULL, nan, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), ('Nancy Landon Kassebaum', 'Nancy', 'Kassebaum', 'Landon', NULL, NULL, NULL, NULL, NULL, '1932-07-29', 'F', 'K000017', NULL, 406188, 14708.0, 'Nancy Kassebaum', 'Q458281', 'kg:/m/021v7x', 16096.0, NULL, 1375.0, NULL, NULL, 'S140', NULL, NULL, NULL, NULL, NULL), ('Michael Joseph Bradley', 'Michael', 'Bradley', 'Joseph', NULL, NULL, NULL, NULL, NULL, '1897-05-24', 'M', 'B000743', NULL, 401702, 954.0, 'Michael J. Bradley', 'Q6831369', 'kg:/m/0d_vmv', 9739.0, NULL, nan, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);",sqlite,city_legislation,N/A,N/A,N/A54364,alien_data,"CREATE TABLE alien_data (544    id INTEGER,545    first_name TEXT,546    last_name TEXT,547    email TEXT,548    gender TEXT,549    type TEXT,550    birth_year INTEGER,551    age INTEGER,552    favorite_food TEXT,553    feeding_frequency TEXT,554    aggressive INTEGER,555    occupation TEXT,556    current_location TEXT,557    state TEXT,558    us_region TEXT,559    country TEXT560);",N/A,"INSERT INTO alien_data (id, first_name, last_name, email, gender, type, birth_year, age, favorite_food, feeding_frequency, aggressive, occupation, current_location, state, us_region, country) VALUES (6466, 'filia', 'rennix', 'frennix4zl@state.tx.us', 'female', 'reptile', 1763, 261, 'godwit, hudsonian', 'monthly', 1, 'chemical engineer', 'scranton', 'pennsylvania', 'mideast', 'united states'), (4654, 'ike', 'gouly', 'igouly3l9@vinaora.com', 'male', 'grey', 1739, 285, 'american bison', 'weekly', 1, 'statistician i', 'lansing', 'michigan', 'great lakes', 'united states'), (20536, 'sayer', 'amner', 'samnerfuf@about.me', 'male', 'nordic', 1821, 203, 'eastern indigo snake', 'yearly', 0, 'financial advisor', 'washington', 'district of columbia', 'mideast', 'united states'), (46217, 'mercy', 'klemt', 'mklemtzns@pagesperso-orange.fr', 'female', 'flatwoods', 1755, 269, 'siskin, pine', 'often', 1, 'structural analysis engineer', 'bakersfield', 'california', 'far west', 'united states'), (2437, 'sonnnie', 'willavoys', 'swillavoys1vo@auda.org.au', 'female', 'nordic', 1955, 69, 'fairy penguin', 'often', 0, 'vp sales', 'saginaw', 'michigan', 'great lakes', 'united states');",sqlite,city_legislation,N/A,N/A,N/A56165,cities,"CREATE TABLE cities (562    city_id INTEGER,563    city_name TEXT,564    latitude REAL,565    longitude REAL,566    country_code_2 TEXT,567    capital INTEGER,568    population REAL,569    insert_date TEXT570);",N/A,"INSERT INTO cities (city_id, city_name, latitude, longitude, country_code_2, capital, population, insert_date) VALUES (14356, 'florida', -76.2386, 3.3275, 'co', 0, 58988.0, '2023-04-05'), (40795, 'hardiya', 84.4961, 25.5301, 'in', 0, 8766.0, '2023-02-15'), (38898, 'khovaling', 69.9728, 38.3386, 'tj', 0, 10601.0, '2023-02-10'), (16699, 'santo antonio da platina', -50.0769, -23.295, 'br', 0, 42707.0, '2021-01-16'), (6105, 'edmonton', -0.0708, 51.6154, 'gb', 0, 82472.0, '2023-06-23');",sqlite,city_legislation,N/A,N/A,N/A57166,legislators_terms,"CREATE TABLE legislators_terms (572    id_bioguide TEXT,573    term_number INTEGER,574    term_id TEXT,575    term_type TEXT,576    term_start TEXT,577    term_end TEXT,578    state TEXT,579    district REAL,580    class REAL,581    party TEXT,582    how TEXT,583    url TEXT,584    address TEXT,585    phone TEXT,586    fax TEXT,587    contact_form TEXT,588    office TEXT,589    state_rank TEXT,590    rss_url TEXT,591    caucus TEXT592);",N/A,"INSERT INTO legislators_terms (id_bioguide, term_number, term_id, term_type, term_start, term_end, state, district, class, party, how, url, address, phone, fax, contact_form, office, state_rank, rss_url, caucus) VALUES ('L000221', 7, 'L000221-7', 'rep', '1977-01-04', '1979-01-03', 'CA', 4.0, NULL, 'Democrat', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), ('M000203', 1, 'M000203-1', 'rep', '1889-12-02', '1891-03-03', 'TX', 2.0, NULL, 'Democrat', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), ('T000224', 0, 'T000224-0', 'rep', '1879-03-18', '1881-03-03', 'IA', 5.0, NULL, 'Republican', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), ('K000311', 1, 'K000311-1', 'rep', '1867-03-04', '1869-03-03', 'PA', 16.0, NULL, 'Republican', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), ('B000909', 8, 'B000909-8', 'rep', '1955-01-05', '1957-01-03', 'OH', 7.0, NULL, 'Republican', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);",sqlite,city_legislation,N/A,N/A,N/A59367,rental,"CREATE TABLE rental (594    rental_id INT,595    rental_date TIMESTAMP,596    inventory_id INT,597    customer_id INT,598    return_date TIMESTAMP,599    staff_id SMALLINT,600    last_update TIMESTAMP601);",N/A,"INSERT INTO rental (rental_id, rental_date, inventory_id, customer_id, return_date, staff_id, last_update) VALUES (11110, '2005-08-02 08:20:31.000', 4311, 4, '2005-08-04 05:06:31.000', 2, '2021-03-06 15:55:12'), (9358, '2005-07-30 18:37:24.000', 712, 302, '2005-08-07 23:34:24.000', 2, '2021-03-06 15:54:58'), (12911, '2005-08-19 04:24:10.000', 1770, 367, '2005-08-26 00:35:10.000', 2, '2021-03-06 15:55:27'), (13218, '2005-08-19 15:39:39.000', 4148, 257, '2005-08-22 17:28:39.000', 1, '2021-03-06 15:55:30'), (14471, '2005-08-21 13:10:40.000', 1254, 395, '2005-08-26 16:49:40.000', 1, '2021-03-06 15:55:41');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A60268,language,"CREATE TABLE language (603    language_id SMALLINT,604    name CHAR(20),605    last_update TIMESTAMP606);",N/A,"INSERT INTO language (language_id, name, last_update) VALUES (1, 'English', '2021-03-06 15:51:48'), (5, 'French', '2021-03-06 15:51:48'), (3, 'Japanese', '2021-03-06 15:51:48'), (4, 'Mandarin', '2021-03-06 15:51:48'), (6, 'German', '2021-03-06 15:51:48');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A60769,store,"CREATE TABLE store (608    store_id INT,609    manager_staff_id SMALLINT,610    address_id INT,611    last_update TIMESTAMP612);",N/A,"INSERT INTO store (store_id, manager_staff_id, address_id, last_update) VALUES (1, 1, 1, '2021-03-06 15:52:00'), (2, 2, 2, '2021-03-06 15:52:00');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A61370,staff,"CREATE TABLE staff (614    staff_id SMALLINT,615    first_name VARCHAR(45),616    last_name VARCHAR(45),617    address_id INT,618    picture BLOB,619    email VARCHAR(50),620    store_id INT,621    active SMALLINT,622    username VARCHAR(16),623    password VARCHAR(40),624    last_update TIMESTAMP625);",N/A,"INSERT INTO staff (staff_id, first_name, last_name, address_id, picture, email, store_id, active, username, password, last_update) VALUES (1, 'Mike', 'Hillyer', 3, NULL, 'Mike.Hillyer@sakilastaff.com', 1, 1, 'Mike', '8cb2237d0679ca88db6464eac60da96345513964', '2021-03-06 15:52:00'), (2, 'Jon', 'Stephens', 4, NULL, 'Jon.Stephens@sakilastaff.com', 2, 1, 'Jon', '8cb2237d0679ca88db6464eac60da96345513964', '2021-03-06 15:52:00');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A62671,city,"CREATE TABLE city (627    city_id INT,628    city VARCHAR(50),629    country_id SMALLINT,630    last_update TIMESTAMP631);",N/A,"INSERT INTO city (city_id, city, country_id, last_update) VALUES (433, 'Roanoke', 103, '2021-03-06 15:51:53'), (572, 'Vitria de Santo Anto', 15, '2021-03-06 15:51:54'), (328, 'Maring', 15, '2021-03-06 15:51:52'), (273, 'Klerksdorp', 85, '2021-03-06 15:51:51'), (431, 'Rio Claro', 15, '2021-03-06 15:51:53');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A63272,actor,"CREATE TABLE actor (633    actor_id numeric,634    first_name VARCHAR(45),635    last_name VARCHAR(45),636    last_update TIMESTAMP637);",N/A,"INSERT INTO actor (actor_id, first_name, last_name, last_update) VALUES (124, 'SCARLETT', 'BENING', '2021-03-06 15:52:00'), (10, 'CHRISTIAN', 'GABLE', '2021-03-06 15:51:59'), (73, 'GARY', 'PENN', '2021-03-06 15:51:59'), (94, 'KENNETH', 'TORN', '2021-03-06 15:51:59'), (134, 'GENE', 'HOPKINS', '2021-03-06 15:52:00');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A63873,staff_list,"CREATE TABLE staff_list (639    ID SMALLINT,640    name ,641    address VARCHAR(50),642    zip_code VARCHAR(10),643    phone VARCHAR(20),644    city VARCHAR(50),645    country VARCHAR(50),646    SID INT647);",N/A,"INSERT INTO staff_list (ID, name, address, zip_code, phone, city, country, SID) VALUES (1, 'Mike Hillyer', '23 Workhaven Lane', NULL, ' ', 'Lethbridge', 'Canada', 1), (2, 'Jon Stephens', '1411 Lillydale Drive', NULL, ' ', 'Woodridge', 'Australia', 2);",sqlite,SQLITE_SAKILA,N/A,N/A,N/A64874,film_category,"CREATE TABLE film_category (649    film_id INT,650    category_id SMALLINT,651    last_update TIMESTAMP652);",N/A,"INSERT INTO film_category (film_id, category_id, last_update) VALUES (21, 1, '2021-03-06 15:53:28'), (686, 13, '2021-03-06 15:53:33'), (161, 12, '2021-03-06 15:53:29'), (982, 1, '2021-03-06 15:53:35'), (487, 4, '2021-03-06 15:53:31');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A65375,film_actor,"CREATE TABLE film_actor (654    actor_id INT,655    film_id INT,656    last_update TIMESTAMP657);",N/A,"INSERT INTO film_actor (actor_id, film_id, last_update) VALUES (105, 283, '2021-03-06 15:53:07'), (144, 260, '2021-03-06 15:53:16'), (22, 146, '2021-03-06 15:52:49'), (124, 814, '2021-03-06 15:53:12'), (190, 679, '2021-03-06 15:53:26');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A65876,address,"CREATE TABLE address (659    address_id INT,660    address VARCHAR(50),661    address2 VARCHAR(50),662    district VARCHAR(20),663    city_id INT,664    postal_code VARCHAR(10),665    phone VARCHAR(20),666    last_update TIMESTAMP667);",N/A,"INSERT INTO address (address_id, address, address2, district, city_id, postal_code, phone, last_update) VALUES (215, '1333 Haldia Street', NULL, ' ', 174, '82161', ' ', '2021-03-06 15:51:56'), (298, '44 Najafabad Way', NULL, ' ', 146, '61391', ' ', '2021-03-06 15:51:56'), (599, '1895 Zhezqazghan Drive', NULL, ' ', 177, '36693', ' ', '2021-03-06 15:51:59'), (331, '1016 Iwakuni Street', NULL, ' ', 269, '49833', ' ', '2021-03-06 15:51:57'), (450, '203 Tambaram Street', NULL, ' ', 161, '73942', ' ', '2021-03-06 15:51:57');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A66877,sales_by_film_category,"CREATE TABLE sales_by_film_category (669    category VARCHAR(25),670    total_sales 671);",N/A,"INSERT INTO sales_by_film_category (category, total_sales) VALUES ('Animation', 4656.3), ('Family', 4226.070000000001), ('Foreign', 4270.67), ('Documentary', 4217.52), ('Horror', 3722.54);",sqlite,SQLITE_SAKILA,N/A,N/A,N/A67278,film_list,"CREATE TABLE film_list (673    FID INT,674    title VARCHAR(255),675    description BLOB SUB_TYPE TEXT,676    category VARCHAR(25),677    price DECIMAL(4,2),678    length SMALLINT,679    rating VARCHAR(10),680    actors 681);",N/A,"INSERT INTO film_list (FID, title, description, category, price, length, rating, actors) VALUES (484, 'JERK PAYCHECK', 'A Touching Character Study of a Pastry Chef And a Database Administrator who must Reach a A Shark in Ancient Japan', 'Classics', 2.99, 172, 'NC-17', 'JULIA BARRYMORE'), (435, 'HOTEL HAPPINESS', 'A Thrilling Yarn of a Pastry Chef And a A Shark who must Challenge a Mad Scientist in The Outback', 'Foreign', 4.99, 181, 'PG-13', 'SANDRA KILMER'), (717, 'REAR TRADING', 'A Awe-Inspiring Reflection of a Forensic Psychologist And a Secret Agent who must Succumb a Pastry Chef in Soviet Georgia', 'Action', 0.99, 97, 'NC-17', 'JUDE CRUISE'), (622, 'NEWSIES STORY', 'A Action-Packed Character Study of a Dog And a Lumberjack who must Outrace a Moose in The Gulf of Mexico', 'Documentary', 0.99, 159, 'G', 'JEFF SILVERSTONE'), (517, 'LESSON CLEOPATRA', 'A Emotional Display of a Man And a Explorer who must Build a Boy in A Manhattan Penthouse', 'Sports', 0.99, 167, 'NC-17', 'LISA MONROE');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A68279,category,"CREATE TABLE category (683    category_id SMALLINT,684    name VARCHAR(25),685    last_update TIMESTAMP686);",N/A,"INSERT INTO category (category_id, name, last_update) VALUES (15, 'Sports', '2021-03-06 15:52:00'), (4, 'Classics', '2021-03-06 15:52:00'), (5, 'Comedy', '2021-03-06 15:52:00'), (12, 'Music', '2021-03-06 15:52:00'), (2, 'Animation', '2021-03-06 15:52:00');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A68780,payment,"CREATE TABLE payment (688    payment_id INT,689    customer_id INT,690    staff_id SMALLINT,691    rental_id INT,692    amount DECIMAL(5,2),693    payment_date TIMESTAMP,694    last_update TIMESTAMP695);",N/A,"INSERT INTO payment (payment_id, customer_id, staff_id, rental_id, amount, payment_date, last_update) VALUES (8867, 328, 1, 13609, 2.99, '2005-08-20 06:11:51.000', '2021-03-06 15:57:11'), (9500, 351, 2, 8512, 4.99, '2005-07-29 09:48:03.000', '2021-03-06 15:57:16'), (7518, 277, 2, 12149, 3.99, '2005-08-18 00:13:51.000', '2021-03-06 15:57:00'), (15182, 566, 1, 11717, 0.99, '2005-08-17 07:44:09.000', '2021-03-06 15:58:02'), (5794, 213, 1, 9477, 4.99, '2005-07-30 23:07:22.000', '2021-03-06 15:56:46');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A69681,inventory,"CREATE TABLE inventory (697    inventory_id INT,698    film_id INT,699    store_id INT,700    last_update TIMESTAMP701);",N/A,"INSERT INTO inventory (inventory_id, film_id, store_id, last_update) VALUES (3748, 820, 1, '2021-03-06 15:52:38'), (2837, 622, 2, '2021-03-06 15:52:31'), (1887, 411, 1, '2021-03-06 15:52:23'), (2164, 467, 2, '2021-03-06 15:52:25'), (149, 31, 1, '2021-03-06 15:52:09');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A70282,customer,"CREATE TABLE customer (703    customer_id INT,704    store_id INT,705    first_name VARCHAR(45),706    last_name VARCHAR(45),707    email VARCHAR(50),708    address_id INT,709    active CHAR(1),710    create_date TIMESTAMP,711    last_update TIMESTAMP712);",N/A,"INSERT INTO customer (customer_id, store_id, first_name, last_name, email, address_id, active, create_date, last_update) VALUES (470, 1, 'GORDON', 'ALLARD', 'GORDON.ALLARD@sakilacustomer.org', 475, '1', '2006-02-14 22:04:37.000', '2021-03-06 15:53:40'), (196, 1, 'ALMA', 'AUSTIN', 'ALMA.AUSTIN@sakilacustomer.org', 200, '1', '2006-02-14 22:04:36.000', '2021-03-06 15:53:37'), (328, 2, 'JEFFREY', 'SPEAR', 'JEFFREY.SPEAR@sakilacustomer.org', 333, '1', '2006-02-14 22:04:37.000', '2021-03-06 15:53:38'), (285, 1, 'MIRIAM', 'MCKINNEY', 'MIRIAM.MCKINNEY@sakilacustomer.org', 290, '1', '2006-02-14 22:04:37.000', '2021-03-06 15:53:38'), (481, 1, 'HERMAN', 'DEVORE', 'HERMAN.DEVORE@sakilacustomer.org', 486, '1', '2006-02-14 22:04:37.000', '2021-03-06 15:53:40');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A71383,sales_by_store,"CREATE TABLE sales_by_store (714    store_id INT,715    store ,716    manager ,717    total_sales 718);",N/A,"INSERT INTO sales_by_store (store_id, store, manager, total_sales) VALUES (1, 'Lethbridge,Canada', 'Mike Hillyer', 33679.79), (2, 'Woodridge,Australia', 'Jon Stephens', 33726.770000000004);",sqlite,SQLITE_SAKILA,N/A,N/A,N/A71984,film,"CREATE TABLE film (720    film_id INT,721    title VARCHAR(255),722    description BLOB SUB_TYPE TEXT,723    release_year VARCHAR(4),724    language_id SMALLINT,725    original_language_id SMALLINT,726    rental_duration SMALLINT,727    rental_rate DECIMAL(4,2),728    length SMALLINT,729    replacement_cost DECIMAL(5,2),730    rating VARCHAR(10),731    special_features VARCHAR(100),732    last_update TIMESTAMP733);",N/A,"INSERT INTO film (film_id, title, description, release_year, language_id, original_language_id, rental_duration, rental_rate, length, replacement_cost, rating, special_features, last_update) VALUES (4, 'AFFAIR PREJUDICE', 'A Fanciful Documentary of a Frisbee And a Lumberjack who must Chase a Monkey in A Shark Tank', '2006', 1, NULL, 5, 2.99, 117, 26.99, 'G', 'Commentaries,Behind the Scenes', '2021-03-06 15:52:00'), (456, 'INCH JET', 'A Fateful Saga of a Womanizer And a Student who must Defeat a Butler in A Monastery', '2006', 1, NULL, 6, 4.99, 167, 18.99, 'NC-17', 'Deleted Scenes', '2021-03-06 15:52:04'), (146, 'CHITTY LOCK', 'A Boring Epistle of a Boat And a Database Administrator who must Kill a Sumo Wrestler in The First Manned Space Station', '2006', 1, NULL, 6, 2.99, 107, 24.99, 'G', 'Commentaries', '2021-03-06 15:52:01'), (460, 'INNOCENT USUAL', 'A Beautiful Drama of a Pioneer And a Crocodile who must Challenge a Student in The Outback', '2006', 1, NULL, 3, 4.99, 178, 26.99, 'PG-13', 'Trailers,Deleted Scenes,Behind the Scenes', '2021-03-06 15:52:04'), (591, 'MONSOON CAUSE', 'A Astounding Tale of a Crocodile And a Car who must Outrace a Squirrel in A U-Boat', '2006', 1, NULL, 6, 4.99, 182, 20.99, 'PG', 'Commentaries,Behind the Scenes', '2021-03-06 15:52:05');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A73485,customer_list,"CREATE TABLE customer_list (735    ID INT,736    name ,737    address VARCHAR(50),738    zip_code VARCHAR(10),739    phone VARCHAR(20),740    city VARCHAR(50),741    country VARCHAR(50),742    notes ,743    SID INT744);",N/A,"INSERT INTO customer_list (ID, name, address, zip_code, phone, city, country, notes, SID) VALUES (4, 'BARBARA JONES', '1566 Inegl Manor', '53561', ' ', 'Myingyan', 'Myanmar', 'active', 2), (45, 'JANET PHILLIPS', '1718 Valencia Street', '37359', ' ', 'Antofagasta', 'Chile', 'active', 1), (53, 'HEATHER MORRIS', '17 Kabul Boulevard', '38594', ' ', 'Nagareyama', 'Japan', 'active', 1), (115, 'WENDY HARRISON', '1107 Nakhon Sawan Avenue', '75149', ' ', 'Nezahualcyotl', 'Mexico', 'active', 1), (46, 'CATHERINE CAMPBELL', '46 Pjatigorsk Lane', '23616', ' ', 'Moscow', 'Russian Federation', 'active', 2);",sqlite,SQLITE_SAKILA,N/A,N/A,N/A74586,film_text,"CREATE TABLE film_text (746    film_id SMALLINT,747    title VARCHAR(255),748    description BLOB SUB_TYPE TEXT749);",N/A,"INSERT INTO film_text (film_id, title, description) VALUES ;",sqlite,SQLITE_SAKILA,N/A,N/A,N/A75087,country,"CREATE TABLE country (751    country_id SMALLINT,752    country VARCHAR(50),753    last_update TIMESTAMP754);",N/A,"INSERT INTO country (country_id, country, last_update) VALUES (21, 'Chad', '2021-03-06 15:51:49'), (72, 'Pakistan', '2021-03-06 15:51:49'), (104, 'Venezuela', '2021-03-06 15:51:49'), (5, 'Anguilla', '2021-03-06 15:51:49'), (86, 'South Korea', '2021-03-06 15:51:49');",sqlite,SQLITE_SAKILA,N/A,N/A,N/A75588,sqlite_sequence,"CREATE TABLE sqlite_sequence (756    name ,757    seq 758);",N/A,"INSERT INTO sqlite_sequence (name, seq) VALUES ('Tournaments', 20), ('Bowlers', 34), ('Teams', 10), ('Tourney_Matches', 57);",sqlite,BowlingLeague,N/A,N/A,N/A75989,Tournaments_Archive,"CREATE TABLE Tournaments_Archive (760    TourneyID INT,761    TourneyDate DATE,762    TourneyLocation TEXT763);",N/A,"INSERT INTO Tournaments_Archive (TourneyID, TourneyDate, TourneyLocation) VALUES ;",sqlite,BowlingLeague,N/A,N/A,N/A76490,Tournaments,"CREATE TABLE Tournaments (765    TourneyID INTEGER,766    TourneyDate DATE,767    TourneyLocation TEXT768);",N/A,"INSERT INTO Tournaments (TourneyID, TourneyDate, TourneyLocation) VALUES (14, '2017-12-04', 'Acapulco Lanes'), (15, '2018-07-12', 'Red Rooster Lanes'), (3, '2017-09-18', 'Bolero Lanes'), (20, '2018-08-16', 'Totem Lanes'), (8, '2017-10-23', 'Red Rooster Lanes');",sqlite,BowlingLeague,N/A,N/A,N/A76991,Bowlers,"CREATE TABLE Bowlers (770    BowlerID INTEGER,771    BowlerLastName TEXT,772    BowlerFirstName TEXT,773    BowlerMiddleInit TEXT,774    BowlerAddress TEXT,775    BowlerCity TEXT,776    BowlerState TEXT,777    BowlerZip TEXT,778    BowlerPhoneNumber TEXT,779    TeamID INT,780    BowlerTotalPins INT,781    BowlerGamesBowled INT,782    BowlerCurrentAverage smallint,783    BowlerCurrentHcp smallint784);",N/A,"INSERT INTO Bowlers (BowlerID, BowlerLastName, BowlerFirstName, BowlerMiddleInit, BowlerAddress, BowlerCity, BowlerState, BowlerZip, BowlerPhoneNumber, TeamID, BowlerTotalPins, BowlerGamesBowled, BowlerCurrentAverage, BowlerCurrentHcp) VALUES (11, 'Kennedy', 'Angel', NULL, '2957 W 33rd', 'Ballard', 'WA', '98154', '(206) 555-7854', 3, 6372, 39, 163, 33), (26, 'Thompson', 'Mary', 'K', '122 Spring Valley Drive', 'Duvall', 'WA', '98019', '(206) 555-8989', 7, 6137, 39, 157, 39), (5, 'Patterson', 'Ann', 'K', '16 Maple Lane', 'Auburn', 'WA', '98002', '(206) 555-3487', 2, 5819, 39, 149, 46), (32, 'Rosales', 'Joe', NULL, '908 W. Capital Way', 'Tacoma', 'WA', '98404', '(206) 555-9482', 8, 5525, 39, 142, 52), (16, 'Sheskey', 'Richard', NULL, '17950 N 59th', 'Seattle', 'WA', '98011', '(206) 555-9893', 4, 5549, 39, 142, 52);",sqlite,BowlingLeague,N/A,N/A,N/A78592,Bowler_Scores_Archive,"CREATE TABLE Bowler_Scores_Archive (786    MatchID INT,787    GameNumber smallint,788    BowlerID INT,789    RawScore smallint,790    HandiCapScore smallint,791    WonGame BOOLEAN792);",N/A,"INSERT INTO Bowler_Scores_Archive (MatchID, GameNumber, BowlerID, RawScore, HandiCapScore, WonGame) VALUES ;",sqlite,BowlingLeague,N/A,N/A,N/A79393,Teams,"CREATE TABLE Teams (794    TeamID INTEGER,795    TeamName TEXT,796    CaptainID INT797);",N/A,"INSERT INTO Teams (TeamID, TeamName, CaptainID) VALUES (3, 'Terrapins', 12), (2, 'Sharks', 5), (8, 'Swordfish', 32), (1, 'Marlins', 2), (9, 'Huckleberrys', 7);",sqlite,BowlingLeague,N/A,N/A,N/A79894,WAZips,"CREATE TABLE WAZips (799    ZIP TEXT,800    City TEXT,801    State TEXT802);",N/A,"INSERT INTO WAZips (ZIP, City, State) VALUES ('98647', 'Skamokawa', 'WA'), ('98164', 'Seattle', 'WA'), ('98683', 'Vancouver', 'WA'), ('99327', 'Cunningham', 'WA'), ('98827', 'Loomis', 'WA');",sqlite,BowlingLeague,N/A,N/A,N/A80395,Tourney_Matches,"CREATE TABLE Tourney_Matches (804    MatchID INTEGER,805    TourneyID INT,806    Lanes TEXT,807    OddLaneTeamID INT,808    EvenLaneTeamID INT809);",N/A,"INSERT INTO Tourney_Matches (MatchID, TourneyID, Lanes, OddLaneTeamID, EvenLaneTeamID) VALUES (22, 6, '07-08', 3, 5), (9, 3, '15-16', 2, 3), (52, 13, '19-20', 4, 5), (25, 7, '13-14', 8, 1), (45, 12, '05-06', 7, 1);",sqlite,BowlingLeague,N/A,N/A,N/A81096,Bowler_Scores,"CREATE TABLE Bowler_Scores (811    MatchID INT,812    GameNumber smallint,813    BowlerID INT,814    RawScore smallint,815    HandiCapScore smallint,816    WonGame BOOLEAN817);",N/A,"INSERT INTO Bowler_Scores (MatchID, GameNumber, BowlerID, RawScore, HandiCapScore, WonGame) VALUES (9, 3, 7, 144, 165, 0), (23, 2, 7, 182, 211, 1), (12, 1, 32, 140, 192, 0), (5, 3, 1, 152, 199, 1), (27, 2, 10, 169, 205, 0);",sqlite,BowlingLeague,N/A,N/A,N/A81897,Match_Games,"CREATE TABLE Match_Games (819    MatchID INT,820    GameNumber smallint,821    WinningTeamID INT822);",N/A,"INSERT INTO Match_Games (MatchID, GameNumber, WinningTeamID) VALUES (27, 3, 6), (48, 3, 6), (8, 2, 6), (13, 2, 5), (44, 3, 4);",sqlite,BowlingLeague,N/A,N/A,N/A82398,Match_Games_Archive,"CREATE TABLE Match_Games_Archive (824    MatchID INT,825    GameNumber smallint,826    WinningTeamID INT827);",N/A,"INSERT INTO Match_Games_Archive (MatchID, GameNumber, WinningTeamID) VALUES ;",sqlite,BowlingLeague,N/A,N/A,N/A82899,Tourney_Matches_Archive,"CREATE TABLE Tourney_Matches_Archive (829    MatchID INT,830    TourneyID INT,831    Lanes TEXT,832    OddLaneTeamID INT,833    EvenLaneTeamID INT834);",N/A,"INSERT INTO Tourney_Matches_Archive (MatchID, TourneyID, Lanes, OddLaneTeamID, EvenLaneTeamID) VALUES ;",sqlite,BowlingLeague,N/A,N/A,N/A835100,locations,"CREATE TABLE locations (836    id INTEGER,837    warehouse INTEGER,838    aisle TEXT,839    position INTEGER840);",N/A,"INSERT INTO locations (id, warehouse, aisle, position) VALUES (217, 2, 'C', 25), (228, 2, 'D', 4), (165, 2, 'B', 5), (211, 2, 'C', 19), (103, 1, 'D', 7);",sqlite,oracle_sql,N/A,N/A,N/A841101,ticker,"CREATE TABLE ticker (842    symbol TEXT,843    day TEXT,844    price REAL845);",N/A,"INSERT INTO ticker (symbol, day, price) VALUES ('BEER', '2019-04-02', 14.2), ('BEER', '2019-04-18', 14.3), ('BEER', '2019-04-08', 14.8), ('BEER', '2019-04-04', 15.7), ('BEER', '2019-04-10', 14.0);",sqlite,oracle_sql,N/A,N/A,N/A846102,web_devices,"CREATE TABLE web_devices (847    day ,848    pc INTEGER,849    tablet INTEGER,850    phone INTEGER851);",N/A,"INSERT INTO web_devices (day, pc, tablet, phone) VALUES ('2019-05-01', 1042, 812, 1610), ('2019-05-02', 967, 1102, 2159);",sqlite,oracle_sql,N/A,N/A,N/A852103,stock,"CREATE TABLE stock (853    symbol TEXT,854    company TEXT855);",N/A,"INSERT INTO stock (symbol, company) VALUES ('BEER', 'Good Beer Trading Co');",sqlite,oracle_sql,N/A,N/A,N/A856104,packaging_relations,"CREATE TABLE packaging_relations (857    packaging_id INTEGER,858    contains_id INTEGER,859    qty INTEGER860);",N/A,"INSERT INTO packaging_relations (packaging_id, contains_id, qty) VALUES (511, 501, 3), (522, 501, 36), (533, 522, 10), (534, 524, 16), (534, 523, 20);",sqlite,oracle_sql,N/A,N/A,N/A861105,picking_line,"CREATE TABLE picking_line (862    picklist_id INTEGER,863    line_no INTEGER,864    location_id INTEGER,865    order_id INTEGER,866    product_id INTEGER,867    qty REAL868);",N/A,"INSERT INTO picking_line (picklist_id, line_no, location_id, order_id, product_id, qty) VALUES (842, 8, 163, 422, 4280, 5.0), (842, 3, 77, 422, 6520, 20.0), (842, 11, 233, 422, 6520, 8.0), (842, 12, 233, 423, 6520, 18.0), (842, 1, 16, 423, 6520, 22.0);",sqlite,oracle_sql,N/A,N/A,N/A869106,server_heartbeat,"CREATE TABLE server_heartbeat (870    server TEXT,871    beat_time TEXT872);",N/A,"INSERT INTO server_heartbeat (server, beat_time) VALUES ('10.0.0.100', '2019-04-10 13:35'), ('10.0.0.100', '2019-04-10 13:40'), ('10.0.0.100', '2019-04-10 13:10'), ('10.0.0.142', '2019-04-10 13:00'), ('10.0.0.142', '2019-04-10 13:20');",sqlite,oracle_sql,N/A,N/A,N/A873107,id_name_coll_type,"CREATE TABLE id_name_coll_type (874    collection_id INTEGER875);",N/A,INSERT INTO id_name_coll_type (collection_id) VALUES ;,sqlite,oracle_sql,N/A,N/A,N/A876108,web_counter_hist,"CREATE TABLE web_counter_hist (877    app_id INTEGER,878    page_no INTEGER,879    day TEXT,880    counter INTEGER881);",N/A,"INSERT INTO web_counter_hist (app_id, page_no, day, counter) VALUES (542, 1, '2019-04-14', 6350), (542, 3, '2019-04-27', 3008), (542, 2, '2019-04-27', 4588), (542, 3, '2019-04-29', 3077), (542, 2, '2019-04-17', 4089);",sqlite,oracle_sql,N/A,N/A,N/A882109,orders,"CREATE TABLE orders (883    id INTEGER,884    customer_id INTEGER,885    ordered TEXT,886    delivery TEXT887);",N/A,"INSERT INTO orders (id, customer_id, ordered, delivery) VALUES (424, 51069, '2019-01-28', NULL), (426, 50741, '2019-02-26', NULL), (425, 51069, '2019-02-17', NULL), (422, 51069, '2019-01-17', NULL), (429, 50042, '2019-03-22', NULL);",sqlite,oracle_sql,N/A,N/A,N/A888110,product_minimums,"CREATE TABLE product_minimums (889    product_id INTEGER,890    qty_minimum REAL,891    qty_purchase REAL892);",N/A,"INSERT INTO product_minimums (product_id, qty_minimum, qty_purchase) VALUES (6520, 100.0, 400.0), (6600, 30.0, 100.0);",sqlite,oracle_sql,N/A,N/A,N/A893111,orderlines,"CREATE TABLE orderlines (894    id INTEGER,895    order_id INTEGER,896    product_id INTEGER,897    qty REAL,898    amount REAL899);",N/A,"INSERT INTO orderlines (id, order_id, product_id, qty, amount) VALUES (9299, 430, 7950, 50.0, 480.0), (9234, 422, 6520, 80.0, 1275.0), (9295, 428, 4280, 90.0, 1925.0), (9287, 426, 6600, 16.0, 320.0), (9233, 422, 4280, 80.0, 1750.0);",sqlite,oracle_sql,N/A,N/A,N/A900112,customers,"CREATE TABLE customers (901    id INTEGER,902    name TEXT903);",N/A,"INSERT INTO customers (id, name) VALUES (50042, 'The White Hart'), (50741, 'Hygge og Humle'), (51007, 'Boom Beer Bar'), (51069, 'Der Wichtelmann');",sqlite,oracle_sql,N/A,N/A,N/A904113,channels_dim,"CREATE TABLE channels_dim (905    id INTEGER,906    name TEXT,907    shortcut TEXT908);",N/A,"INSERT INTO channels_dim (id, name, shortcut) VALUES (42, 'Twitter', 'tw'), (44, 'Facebook', 'fb');",sqlite,oracle_sql,N/A,N/A,N/A909114,gender_dim,"CREATE TABLE gender_dim (910    letter TEXT,911    name TEXT912);",N/A,"INSERT INTO gender_dim (letter, name) VALUES ('F', 'Female'), ('M', 'Male');",sqlite,oracle_sql,N/A,N/A,N/A913115,product_groups,"CREATE TABLE product_groups (914    id INTEGER,915    name TEXT916);",N/A,"INSERT INTO product_groups (id, name) VALUES (142, 'Stout'), (152, 'Belgian'), (202, 'Wheat'), (232, 'IPA');",sqlite,oracle_sql,N/A,N/A,N/A917116,product_alcohol,"CREATE TABLE product_alcohol (918    product_id INTEGER,919    sales_volume REAL,920    abv REAL921);",N/A,"INSERT INTO product_alcohol (product_id, sales_volume, abv) VALUES (5430, 330.0, 6.5), (7790, 500.0, 5.5), (5310, 330.0, 5.0), (7870, 330.0, 4.5), (6520, 500.0, 4.5);",sqlite,oracle_sql,N/A,N/A,N/A922117,id_name_coll_entries,"CREATE TABLE id_name_coll_entries (923    collection_id INTEGER,924    id INTEGER,925    name TEXT926);",N/A,"INSERT INTO id_name_coll_entries (collection_id, id, name) VALUES ;",sqlite,oracle_sql,N/A,N/A,N/A927118,purchases,"CREATE TABLE purchases (928    id INTEGER,929    purchased TEXT,930    brewery_id INTEGER,931    product_id INTEGER,932    qty INTEGER,933    cost REAL934);",N/A,"INSERT INTO purchases (id, purchased, brewery_id, product_id, qty, cost) VALUES (739, '2018-04-26', 518, 6520, 74, 518.0), (730, '2018-02-28', 523, 7870, 89, 640.0), (733, '2018-03-27', 523, 6600, 21, 151.0), (773, '2018-11-27', 523, 6600, 8, 60.0), (770, '2018-10-29', 523, 7870, 90, 648.0);",sqlite,oracle_sql,N/A,N/A,N/A935119,customer_favorites,"CREATE TABLE customer_favorites (936    customer_id INTEGER,937    favorite_list TEXT938);",N/A,"INSERT INTO customer_favorites (customer_id, favorite_list) VALUES (50042, '4040,5310'), (50741, '5430,7790,7870'), (51007, NULL), (51069, '6520');",sqlite,oracle_sql,N/A,N/A,N/A939120,monthly_sales,"CREATE TABLE monthly_sales (940    product_id INTEGER,941    mth TEXT,942    qty INTEGER943);",N/A,"INSERT INTO monthly_sales (product_id, mth, qty) VALUES (7790, '2018-06-01', 46), (4160, '2016-05-01', 0), (4040, '2016-10-01', 12), (7790, '2018-05-01', 23), (4160, '2016-10-01', 4);",sqlite,oracle_sql,N/A,N/A,N/A944121,picking_list,"CREATE TABLE picking_list (945    id INTEGER,946    created TEXT,947    picker_emp_id INTEGER948);",N/A,"INSERT INTO picking_list (id, created, picker_emp_id) VALUES (841, '2019-01-16 14:03:41', 149), (842, '2019-01-19 15:57:42', 152);",sqlite,oracle_sql,N/A,N/A,N/A949122,packaging,"CREATE TABLE packaging (950    id INTEGER,951    name TEXT952);",N/A,"INSERT INTO packaging (id, name) VALUES (531, 'Pallet of L'), (501, 'Bottle 330cl'), (521, 'Box Large'), (534, 'Pallet Mix SG'), (533, 'Pallet Mix MS');",sqlite,oracle_sql,N/A,N/A,N/A953123,web_demographics,"CREATE TABLE web_demographics (954    day ,955    m_tw_cnt INTEGER,956    m_tw_qty INTEGER,957    m_fb_cnt INTEGER,958    m_fb_qty INTEGER,959    f_tw_cnt INTEGER,960    f_tw_qty INTEGER,961    f_fb_cnt INTEGER,962    f_fb_qty INTEGER963);",N/A,"INSERT INTO web_demographics (day, m_tw_cnt, m_tw_qty, m_fb_cnt, m_fb_qty, f_tw_cnt, f_tw_qty, f_fb_cnt, f_fb_qty) VALUES ('2019-05-01', 1232, 86, 1017, 64, 651, 76, 564, 68), ('2019-05-02', 1438, 142, 1198, 70, 840, 92, 752, 78);",sqlite,oracle_sql,N/A,N/A,N/A964124,customer_reviews,"CREATE TABLE customer_reviews (965    customer_id INTEGER,966    review_list TEXT967);",N/A,"INSERT INTO customer_reviews (customer_id, review_list) VALUES (50042, '4040:A,6600:C,7950:B'), (50741, '4160:A'), (51007, NULL), (51069, '4280:B,7790:B');",sqlite,oracle_sql,N/A,N/A,N/A968125,web_apps,"CREATE TABLE web_apps (969    id INTEGER,970    name TEXT971);",N/A,"INSERT INTO web_apps (id, name) VALUES (542, 'Webshop');",sqlite,oracle_sql,N/A,N/A,N/A972126,products,"CREATE TABLE products (973    id INTEGER,974    name TEXT,975    group_id INTEGER976);",N/A,"INSERT INTO products (id, name, group_id) VALUES (4160, 'Reindeer Fuel', 142), (4280, 'Hoppy Crude Oil', 142), (6600, 'Hazy Pink Cloud', 202), (6520, 'Der Helle Kumpel', 202), (7870, 'Ghost of Hops', 232);",sqlite,oracle_sql,N/A,N/A,N/A977127,employees,"CREATE TABLE employees (978    id INTEGER,979    name TEXT,980    title TEXT,981    supervisor_id INTEGER982);",N/A,"INSERT INTO employees (id, name, title, supervisor_id) VALUES (153, 'Dan Hoeffler', 'IT Supporter', 143), (145, 'Zoe Thorston', 'IT Developer', 143), (146, 'Lim Tok Lo', 'Warehouse Manager', 147), (154, 'Simon Chang', 'Retail Salesman', 151), (155, 'Susanne Hoff', 'Janitor', 146);",sqlite,oracle_sql,N/A,N/A,N/A983128,id_name_type,"CREATE TABLE id_name_type (984    id INTEGER,985    name TEXT986);",N/A,"INSERT INTO id_name_type (id, name) VALUES ;",sqlite,oracle_sql,N/A,N/A,N/A987129,inventory,"CREATE TABLE inventory (988    id INTEGER,989    location_id INTEGER,990    product_id INTEGER,991    purchase_id INTEGER,992    qty REAL993);",N/A,"INSERT INTO inventory (id, location_id, product_id, purchase_id, qty) VALUES (1436, 51, 7870, 770, 42.0), (1160, 220, 4040, 721, 48.0), (1169, 149, 6600, 723, 19.0), (1409, 125, 7950, 765, 48.0), (1439, 87, 7870, 770, 48.0);",sqlite,oracle_sql,N/A,N/A,N/A994130,breweries,"CREATE TABLE breweries (995    id INTEGER,996    name TEXT997);",N/A,"INSERT INTO breweries (id, name) VALUES (518, 'Balthazar Brauerei'), (523, 'Happy Hoppy Hippo'), (536, 'Brewing Barbarian');",sqlite,oracle_sql,N/A,N/A,N/A998131,monthly_budget,"CREATE TABLE monthly_budget (999    product_id INTEGER,1000    mth TEXT,1001    qty REAL1002);",N/A,"INSERT INTO monthly_budget (product_id, mth, qty) VALUES (6520, '2019-11-01', 40.0), (6520, '2019-08-01', 60.0), (6600, '2019-06-01', 20.0), (6600, '2018-11-01', 6.0), (6520, '2018-05-01', 40.0);",sqlite,oracle_sql,N/A,N/A,N/A1003132,emp_hire_periods,"CREATE TABLE emp_hire_periods (1004    emp_id INTEGER,1005    start_ TEXT,1006    end_ TEXT,1007    title TEXT1008);",N/A,"INSERT INTO emp_hire_periods (emp_id, start_, end_, title) VALUES (144, '2010-07-01', '2013-07-01', 'Sales Manager'), (145, '2014-02-01', NULL, 'IT Developer'), (147, '2014-10-01', '2015-05-01', 'Delivery Manager'), (145, '2019-02-01', NULL, 'Scrum Master'), (143, '2014-04-01', '2015-10-01', 'Code Tester');",sqlite,oracle_sql,N/A,N/A,N/A1009133,web_page_visits,"CREATE TABLE web_page_visits (1010    client_ip TEXT,1011    visit_time TEXT,1012    app_id INTEGER,1013    page_no INTEGER1014);",N/A,"INSERT INTO web_page_visits (client_ip, visit_time, app_id, page_no) VALUES ('104.130.89.12', '2019-04-20 08:28:55', 542, 4), ('85.237.86.200', '2019-04-20 11:58:39', 542, 2), ('104.130.89.12', '2019-04-20 15:02:44', 542, 2), ('104.130.89.12', '2019-04-20 15:04:01', 542, 2), ('104.130.89.12', '2019-04-20 09:03:34', 542, 2);",sqlite,oracle_sql,N/A,N/A,N/A1015134,favorite_coll_type,"CREATE TABLE favorite_coll_type (1016    id INTEGER1017);",N/A,INSERT INTO favorite_coll_type (id) VALUES ;,sqlite,oracle_sql,N/A,N/A,N/A1018135,conway_gen_zero,"CREATE TABLE conway_gen_zero (1019    x INTEGER,1020    y INTEGER,1021    alive INTEGER1022);",N/A,"INSERT INTO conway_gen_zero (x, y, alive) VALUES ;",sqlite,oracle_sql,N/A,N/A,N/A1023136,web_pages,"CREATE TABLE web_pages (1024    app_id INTEGER,1025    page_no INTEGER,1026    friendly_url TEXT1027);",N/A,"INSERT INTO web_pages (app_id, page_no, friendly_url) VALUES (542, 1, '/Shop'), (542, 2, '/Categories'), (542, 3, '/Breweries'), (542, 4, '/About');",sqlite,oracle_sql,N/A,N/A,N/A1028137,picking_log,"CREATE TABLE picking_log (1029    picklist_id INTEGER,1030    log_time TEXT,1031    activity TEXT,1032    location_id INTEGER,1033    pickline_no INTEGER1034);",N/A,"INSERT INTO picking_log (picklist_id, log_time, activity, location_id, pickline_no) VALUES (841, '2019-01-16 14:06:01', 'D', 16.0, nan), (841, '2019-01-16 14:09:02', 'P', 114.0, 5.0), (842, '2019-01-19 16:07:03', 'D', 165.0, nan), (842, '2019-01-19 16:03:20', 'D', 77.0, nan), (842, '2019-01-19 16:01:12', 'D', nan, nan);",sqlite,oracle_sql,N/A,N/A,N/A1035138,supplementary_demographics,"CREATE TABLE supplementary_demographics (1036    cust_id INTEGER,1037    education TEXT,1038    occupation TEXT,1039    household_size TEXT,1040    yrs_residence INTEGER,1041    affinity_card INTEGER,1042    cricket INTEGER,1043    baseball INTEGER,1044    tennis INTEGER,1045    soccer INTEGER,1046    golf INTEGER,1047    unknown INTEGER,1048    misc INTEGER,1049    comments TEXT1050);",N/A,"INSERT INTO supplementary_demographics (cust_id, education, occupation, household_size, yrs_residence, affinity_card, cricket, baseball, tennis, soccer, golf, unknown, misc, comments) VALUES (103084, 'HS-grad', 'Other', '1', 2, 0, 0, 0, 0, 1, 1, 1, 0, 'Affinity card is great. I think it is a hassle to have to remember to bring it in every time though.'), (103699, '< Bach.', 'Protec.', '3', 3, 1, 1, 1, 0, 1, 1, 0, 0, 'Shopping at your store is a hassle. I rarely shop there and usually forget to bring your new loyalty card and hence never get the items at the sale price.  Can a store manager look up my account on-line?'), (104319, 'Bach.', 'Prof.', '9+', 4, 0, 1, 1, 1, 1, 1, 0, 0, 'The more times that I shop at your store, the more times I am impressed.  Don''t change anything'), (100144, '< Bach.', 'Exec.', '2', 4, 1, 1, 1, 1, 1, 1, 0, 0, 'I am not going to waste my time filling up this three page form. Lousy idea.'), (102128, 'HS-grad', 'Other', '9+', 4, 0, 1, 1, 1, 1, 1, 0, 0, 'I purchased a new model recently, but the instructions weren''t included.  Could you ship them to me directly?');",sqlite,complex_oracle,N/A,N/A,N/A1051139,times,"CREATE TABLE times (1052    time_id DATE,1053    day_name TEXT,1054    day_number_in_week INTEGER,1055    day_number_in_month INTEGER,1056    calendar_week_number INTEGER,1057    fiscal_week_number INTEGER,1058    week_ending_day DATE,1059    week_ending_day_id INTEGER,1060    calendar_month_number INTEGER,1061    fiscal_month_number INTEGER,1062    calendar_month_desc TEXT,1063    calendar_month_id INTEGER,1064    fiscal_month_desc TEXT,1065    fiscal_month_id INTEGER,1066    days_in_cal_month INTEGER,1067    days_in_fis_month INTEGER,1068    end_of_cal_month DATE,1069    end_of_fis_month DATE,1070    calendar_month_name TEXT,1071    fiscal_month_name TEXT,1072    calendar_quarter_desc CHAR(7),1073    calendar_quarter_id INTEGER,1074    fiscal_quarter_desc CHAR(7),1075    fiscal_quarter_id INTEGER,1076    days_in_cal_quarter INTEGER,1077    days_in_fis_quarter INTEGER,1078    end_of_cal_quarter DATE,1079    end_of_fis_quarter DATE,1080    calendar_quarter_number INTEGER,1081    fiscal_quarter_number INTEGER,1082    calendar_year INTEGER,1083    calendar_year_id INTEGER,1084    fiscal_year INTEGER,1085    fiscal_year_id INTEGER,1086    days_in_cal_year INTEGER,1087    days_in_fis_year INTEGER,1088    end_of_cal_year DATE,1089    end_of_fis_year DATE1090);",N/A,"INSERT INTO times (time_id, day_name, day_number_in_week, day_number_in_month, calendar_week_number, fiscal_week_number, week_ending_day, week_ending_day_id, calendar_month_number, fiscal_month_number, calendar_month_desc, calendar_month_id, fiscal_month_desc, fiscal_month_id, days_in_cal_month, days_in_fis_month, end_of_cal_month, end_of_fis_month, calendar_month_name, fiscal_month_name, calendar_quarter_desc, calendar_quarter_id, fiscal_quarter_desc, fiscal_quarter_id, days_in_cal_quarter, days_in_fis_quarter, end_of_cal_quarter, end_of_fis_quarter, calendar_quarter_number, fiscal_quarter_number, calendar_year, calendar_year_id, fiscal_year, fiscal_year_id, days_in_cal_year, days_in_fis_year, end_of_cal_year, end_of_fis_year) VALUES ('2020-04-11', 'Saturday', 6, 11, 15, 15, '2020-04-12', 1531, 4, 4, '2020-04', 1687, '2020-04', 1735, 30, 28, '2020-04-30', '2020-04-25', 'April', 'April', '2020-02', 1774, '2020-02', 1790, 91, 91, '2020-06-30', '2020-06-27', 2, 2, 2020, 1803, 2020, 1807, 366, 364, '2020-12-31', '2020-12-26'), ('2023-05-31', 'Wednesday', 3, 31, 22, 22, '2023-06-04', 1991, 5, 6, '2023-05', 1961, '2023-06', 1992, 31, 35, '2023-05-31', '2023-06-30', 'May', 'June', '2023-02', 1922, '2023-02', 1925, 91, 91, '2023-06-30', '2023-06-30', 2, 2, 2023, 1813, 2023, 1810, 365, 364, '2023-12-31', '2023-12-29'), ('2020-10-11', 'Sunday', 7, 11, 41, 41, '2020-10-11', 1577, 10, 10, '2020-10', 1693, '2020-10', 1741, 31, 35, '2020-10-31', '2020-10-31', 'October', 'October', '2020-04', 1776, '2020-04', 1792, 92, 91, '2020-12-31', '2020-12-26', 4, 4, 2020, 1803, 2020, 1807, 366, 364, '2020-12-31', '2020-12-26'), ('2020-07-10', 'Friday', 5, 10, 28, 28, '2020-07-12', 1534, 7, 7, '2020-07', 1690, '2020-07', 1738, 31, 28, '2020-07-31', '2020-07-25', 'July', 'July', '2020-03', 1775, '2020-03', 1791, 92, 91, '2020-09-30', '2020-09-26', 3, 3, 2020, 1803, 2020, 1807, 366, 364, '2020-12-31', '2020-12-26'), ('2021-11-28', 'Sunday', 7, 28, 48, 48, '2021-11-28', 1476, 11, 12, '2021-11', 1706, '2021-12', 1755, 30, 35, '2021-11-30', '2021-12-31', 'November', 'December', '2021-04', 1780, '2021-04', 1796, 92, 98, '2021-12-31', '2021-12-31', 4, 4, 2021, 1804, 2021, 1808, 365, 371, '2021-12-31', '2021-12-31');",sqlite,complex_oracle,N/A,N/A,N/A1091140,customers,"CREATE TABLE customers (1092    cust_id INTEGER,1093    cust_first_name TEXT,1094    cust_last_name TEXT,1095    cust_gender CHAR(1),1096    cust_year_of_birth INTEGER,1097    cust_marital_status TEXT,1098    cust_street_address TEXT,1099    cust_postal_code TEXT,1100    cust_city TEXT,1101    cust_city_id INTEGER,1102    cust_state_province TEXT,1103    cust_state_province_id INTEGER,1104    country_id INTEGER,1105    cust_main_phone_number TEXT,1106    cust_income_level TEXT,1107    cust_credit_limit REAL,1108    cust_email TEXT,1109    cust_total TEXT,1110    cust_total_id INTEGER,1111    cust_src_id INTEGER,1112    cust_eff_from DATE,1113    cust_eff_to DATE,1114    cust_valid CHAR(1)1115);",N/A,"INSERT INTO customers (cust_id, cust_first_name, cust_last_name, cust_gender, cust_year_of_birth, cust_marital_status, cust_street_address, cust_postal_code, cust_city, cust_city_id, cust_state_province, cust_state_province_id, country_id, cust_main_phone_number, cust_income_level, cust_credit_limit, cust_email, cust_total, cust_total_id, cust_src_id, cust_eff_from, cust_eff_to, cust_valid) VALUES (22465, 'Polly', 'Ingram', 'F', 1950, 'single', '77 East Middlesex Avenue', '61189', 'Evinston', 51459, 'FL', 52595, 52790, '598-746-5594', 'D: 70,000 - 89,999', 3000.0, 'Ingram@company.example.com', 'Customer total', 52772, NULL, '2019-01-01', NULL, 'I'), (19879, 'Homer', 'Leach', 'M', 1958, 'married', '17 East Yukon Koyukuk Court', '55526', 'Alma', 51056, 'AR', 52540, 52790, '529-557-1883', 'E: 90,000 - 109,999', 1500.0, 'Leach@company.example.com', 'Customer total', 52772, NULL, '2019-01-01', NULL, 'I'), (11668, 'Forrest', 'Lauder', 'M', 1969, NULL, '7 South Conecuh Circle', '57339', 'Auckland', 51081, 'Auckland', 52549, 52785, '181-465-2885', 'G: 130,000 - 149,999', 10000.0, 'Lauder@company.example.com', 'Customer total', 52772, NULL, '2019-01-01', NULL, 'I'), (1717, 'Grady', 'Ladd', 'M', 1967, NULL, '37 Shawano Street', '37400', 'Yokohama', 52526, 'Kanagawa', 52634, 52782, '695-206-8041', 'F: 110,000 - 129,999', 10000.0, 'Ladd@company.example.com', 'Customer total', 52772, NULL, '2019-01-01', NULL, 'I'), (15489, 'Tammy', 'Valdez', 'M', 1959, 'single', '57 South Montour Drive', '88021', 'Sully', 52333, 'IA', 52618, 52790, '173-360-7878', 'F: 110,000 - 129,999', 9000.0, 'Valdez@company.example.com', 'Customer total', 52772, NULL, '2019-01-01', NULL, 'A');",sqlite,complex_oracle,N/A,N/A,N/A1116141,currency,"CREATE TABLE currency (1117    country TEXT,1118    year INTEGER,1119    month INTEGER,1120    to_us REAL1121);",N/A,"INSERT INTO currency (country, year, month, to_us) VALUES ('United States of Ame', 2020, 11, 1.0), ('Brazil', 2019, 12, 1.0), ('Hungary', 2019, 10, 1.0), ('Nigeria', 2019, 12, 1.0), ('United Kingdom', 2020, 10, 1.0);",sqlite,complex_oracle,N/A,N/A,N/A1122142,channels,"CREATE TABLE channels (1123    channel_id INTEGER,1124    channel_desc TEXT,1125    channel_class TEXT,1126    channel_class_id INTEGER,1127    channel_total TEXT,1128    channel_total_id INTEGER1129);",N/A,"INSERT INTO channels (channel_id, channel_desc, channel_class, channel_class_id, channel_total, channel_total_id) VALUES (4, 'Internet', 'Indirect', 13, 'Channel total', 1), (9, 'Tele Sales', 'Direct', 12, 'Channel total', 1), (5, 'Catalog', 'Indirect', 13, 'Channel total', 1), (2, 'Partners', 'Others', 14, 'Channel total', 1), (3, 'Direct Sales', 'Direct', 12, 'Channel total', 1);",sqlite,complex_oracle,N/A,N/A,N/A1130143,promotions,"CREATE TABLE promotions (1131    promo_id INTEGER,1132    promo_name TEXT,1133    promo_subcategory TEXT,1134    promo_subcategory_id INTEGER,1135    promo_category TEXT,1136    promo_category_id INTEGER,1137    promo_cost REAL,1138    promo_begin_date DATE,1139    promo_end_date DATE,1140    promo_total TEXT,1141    promo_total_id INTEGER1142);",N/A,"INSERT INTO promotions (promo_id, promo_name, promo_subcategory, promo_subcategory_id, promo_category, promo_category_id, promo_cost, promo_begin_date, promo_end_date, promo_total, promo_total_id) VALUES (508, 'newspaper promotion #19-508', 'coupon news', 19, 'newspaper', 8, 91800.0, '2021-08-19', '2021-09-19', 'Promotion total', 1), (278, 'radio promotion #32-278', 'radio program sponsorship', 32, 'radio', 10, 66800.0, '2021-05-21', '2021-06-21', 'Promotion total', 1), (265, 'newspaper promotion #16-265', 'ad news', 16, 'newspaper', 8, 61500.0, '2021-05-31', '2021-06-30', 'Promotion total', 1), (244, 'magazine promotion #18-244', 'coupon magazine', 18, 'magazine', 7, 46100.0, '2021-02-21', '2021-03-21', 'Promotion total', 1), (491, 'newspaper promotion #16-491', 'ad news', 16, 'newspaper', 8, 76800.0, '2021-05-08', '2021-06-08', 'Promotion total', 1);",sqlite,complex_oracle,N/A,N/A,N/A1143144,countries,"CREATE TABLE countries (1144    country_id INTEGER,1145    country_iso_code CHAR(2),1146    country_name TEXT,1147    country_subregion TEXT,1148    country_subregion_id INTEGER,1149    country_region TEXT,1150    country_region_id INTEGER,1151    country_total TEXT,1152    country_total_id INTEGER1153);",N/A,"INSERT INTO countries (country_id, country_iso_code, country_name, country_subregion, country_subregion_id, country_region, country_region_id, country_total, country_total_id) VALUES (52775, 'BR', 'Brazil', 'Southern America', 52798, 'Americas', 52801, 'World total', 52806), (52789, 'GB', 'United Kingdom', 'Western Europe', 52799, 'Europe', 52803, 'World total', 52806), (52790, 'US', 'United States of America', 'Northern America', 52797, 'Americas', 52801, 'World total', 52806), (52792, 'MX', 'Mexico', 'Northern America', 52797, 'Americas', 52801, 'World total', 52806), (52771, 'CN', 'China', 'Asia', 52793, 'Asia', 52802, 'World total', 52806);",sqlite,complex_oracle,N/A,N/A,N/A1154145,sales,"CREATE TABLE sales (1155    prod_id INTEGER,1156    cust_id INTEGER,1157    time_id DATE,1158    channel_id INTEGER,1159    promo_id INTEGER,1160    quantity_sold INTEGER,1161    amount_sold REAL1162);",N/A,"INSERT INTO sales (prod_id, cust_id, time_id, channel_id, promo_id, quantity_sold, amount_sold) VALUES (26, 1342, '2019-04-13', 3, 999, 1, 168.58), (36, 2175, '2020-10-17', 4, 999, 1, 42.09), (128, 9234, '2019-08-05', 3, 350, 1, 28.86), (143, 2144, '2021-06-03', 3, 999, 1, 22.17), (118, 1942, '2020-04-27', 2, 999, 1, 8.13);",sqlite,complex_oracle,N/A,N/A,N/A1163146,products,"CREATE TABLE products (1164    prod_id INTEGER,1165    prod_name TEXT,1166    prod_desc TEXT,1167    prod_subcategory TEXT,1168    prod_subcategory_id INTEGER,1169    prod_subcategory_desc TEXT,1170    prod_category TEXT,1171    prod_category_id INTEGER,1172    prod_category_desc TEXT,1173    prod_weight_class INTEGER,1174    prod_unit_of_measure TEXT,1175    prod_pack_size TEXT,1176    supplier_id INTEGER,1177    prod_status TEXT,1178    prod_list_price REAL,1179    prod_min_price REAL,1180    prod_total TEXT,1181    prod_total_id INTEGER,1182    prod_src_id INTEGER,1183    prod_eff_from DATE,1184    prod_eff_to DATE,1185    prod_valid CHAR(1)1186);",N/A,"INSERT INTO products (prod_id, prod_name, prod_desc, prod_subcategory, prod_subcategory_id, prod_subcategory_desc, prod_category, prod_category_id, prod_category_desc, prod_weight_class, prod_unit_of_measure, prod_pack_size, supplier_id, prod_status, prod_list_price, prod_min_price, prod_total, prod_total_id, prod_src_id, prod_eff_from, prod_eff_to, prod_valid) VALUES (14, 'Pitching Machine and Batting Cage Combo', 'Pitching Machine and Batting Cage Combo', 'Training Aids and Equipment', 2035, 'Training Aids and Equipment', 'Baseball', 203, 'Baseball', 1, 'U', 'P', 1, 'STATUS', 999.99, 999.99, 'TOTAL', 1, '', '2019-01-01 00:00:00', '', 'A'), (127, 'Genuine Series MIX Wood Bat', 'Genuine Series MIX Wood Bat', 'Bats', 2036, 'Bats', 'Baseball', 203, 'Baseball', 1, 'U', 'P', 1, 'STATUS', 36.99, 36.99, 'TOTAL', 1, '', '2019-01-01 00:00:00', '', 'A'), (23, 'Plastic Cricket Bat', 'Plastic - Beach Cricket Bat', 'Cricket Bat', 2051, 'Cricket', 'Cricket', 205, 'Cricket', 1, 'U', 'P', 1, 'STATUS', 21.99, 21.99, 'TOTAL', 1, '', '2019-01-01 00:00:00', '', 'A'), (50, 'Cricket Gloves', 'Cricket Gloves', 'Cricket', 2055, 'Cricket', 'Cricket', 205, 'Cricket', 1, 'U', 'P', 1, 'STATUS', 19.99, 19.99, 'TOTAL', 1, '', '2019-01-01 00:00:00', '', 'A'), (43, 'Team shirt', 'Australian Cricket Team', 'Cricket Fan Gear', 2054, 'Cricket Fan Gear', 'Cricket', 205, 'Cricket', 1, 'U', 'P', 1, 'STATUS', 44.99, 44.99, 'TOTAL', 1, '', '2019-01-01 00:00:00', '', 'A');",sqlite,complex_oracle,N/A,N/A,N/A1187147,costs,"CREATE TABLE costs (1188    prod_id INTEGER,1189    time_id DATE,1190    promo_id INTEGER,1191    channel_id INTEGER,1192    unit_cost REAL,1193    unit_price REAL1194);",N/A,"INSERT INTO costs (prod_id, time_id, promo_id, channel_id, unit_cost, unit_price) VALUES (22, '2019-11-12', 999, 3, 23.08, 26.29), (41, '2022-07-15', 999, 3, 37.76, 48.65), (45, '2021-11-15', 999, 2, 44.04, 48.78), (29, '2022-08-14', 999, 2, 423.19, 530.86), (123, '2019-02-24', 999, 3, 44.37, 64.99);",sqlite,complex_oracle,N/A,N/A,N/A1195148,order_items,"CREATE TABLE order_items (1196    order_id TEXT,1197    order_item_id INTEGER,1198    product_id TEXT,1199    seller_id TEXT,1200    shipping_limit_date TEXT,

Showing the first 1,200 of 6721 lines. Download the file for the rest.