Model: salmane11/BanQL-1b
Author: salmane11
Pipeline: text-generation
Library: transformers
Tags: transformers, safetensors, gpt_bigcode, text-generation, text-to-SQL, SQL, code-generation, NLQ-to-SQL, text2SQL, en, dataset:salmane11/BanQies, base_model:bigcode/starcoderbase-1b, base_model:finetune:bigcode/starcoderbase-1b, text-generation-inference, endpoints_compatible, region:us
Base models (finetune): id: bigcode/starcoderbase-1b
Card metadata: library_name: transformers
tags: text-to-SQL, SQL, code-generation, NLQ-to-SQL, text2SQL
inference: parameters: max_length: 200
widget: text: CREATE TABLE Loans 
{ 
    loan_id number, 
    client_id number, 
    budget real, 
    duration number, 
    interest real, 
    status varchar 
} 
 CREATE TABLE Clients 
{ 
    client_id number, 
    first_name varchar, 
    last_name varchar, 
    email varchar, 
    city varchar, 
    year_of_birth number 
} 
 CREATE TABLE Accounts 
{ 
    account_id number, 
    client_id number, 
    balance real, 
    type varchar 
} 
 CREATE TABLE Deposits 
{ 
    deposit_id number, 
    account_id number, 
    source varchar, 
    amount real 
} 
 -- Using valid SQLite, answer the following question for the tables provided above. 
 -- What is the duration and budget of the loan id 16342? 
 SELECT 
example_title: Loan duration, text: CREATE TABLE Transactions 
{ 
    transaction_id number, 
    timestamp_id number, 
    primary_contract_id number, 
    client_id number, 
    beneficiary_id number, 
    transaction_amount real, 
    is_fraudulent boolean, 
    product_family_code varchar, 
    amount_currency varchar 
} 
 CREATE TABLE Beneficiary 
{ 
    beneficiary_id number, 
    bank_branch_id number, 
    country_name varchar, 
    country_code varchar 
} 
 CREATE TABLE Source 
{ 
    primary_contract_id number, 
    client_id number, 
    counterparty_bank_branch_id number, 
    counterparty_donor_id number 
} 
 CREATE TABLE Time 
{ 
    timestamp_id number, 
    week_number number, 
    day_number number, 
    hour_number number, 
    day_name varchar, 
    year number, 
    month_number number 
} 
 -- Using valid SQLite, answer the following question for the tables provided above. 
 -- How many transactions for the client id 15482? 
 SELECT 
example_title: Client Transactions
datasets: salmane11/BanQies
language: en
base_model: bigcode/starcoderbase-1b
Likes: 0 | All-time downloads: 59
Created: 2024-05-13 14:29:30