Model: pavankumarbalijepalli/phi2-nl2sql-lora
Author: pavankumarbalijepalli
Pipeline: text-generation
Library: transformers
Tags: transformers, safetensors, phi, text-generation, peft, nl2sql, custom_code, en, dataset:b-mc2/sql-create-context, arxiv:1910.09700, license:mit, text-generation-inference, endpoints_compatible, 4-bit, bitsandbytes, region:us
Card metadata: license: mit
datasets: b-mc2/sql-create-context
language: en
metrics: accuracy, code_eval
library_name: transformers
pipeline_tag: text-generation
tags: peft, nl2sql
widget: text: ### Task
Generate a SQL query to answer the following question:
`How many heads of the departments are older than 56?`

### Database Schema
The query will run on a database with the following schema:
CREATE TABLE head (age INTEGER)

### Answer
Given the database schema, here is the SQL query that answers `How many heads of the departments are older than 56?`:
```sql
example_title: One Table, text: ### Task
Generate a SQL query to answer the following question:
`How many departments are led by heads who are not mentioned?`

### Database Schema
The query will run on a database with the following schema:
CREATE TABLE management (department_id VARCHAR);
CREATE TABLE department (department_id VARCHAR)

### Answer
Given the database schema, here is the SQL query that answers `How many departments are led by heads who are not mentioned?`:
```sql
example_title: Two Tables
Likes: 1 | All-time downloads: 190
Created: 2024-02-20 22:44:01