Model: motherduckdb/DuckDB-NSQL-7B-v0.1
Author: motherduckdb
Pipeline: text-generation
Library: transformers
Tags: transformers, safetensors, llama, text-generation, base_model:meta-llama/Llama-2-7b, base_model:finetune:meta-llama/Llama-2-7b, license:llama2, text-generation-inference, endpoints_compatible, deploy:azure, region:us
Base models (finetune): id: meta-llama/Llama-2-7b
Card metadata: license: llama2
inference: parameters: do_sample: no
max_length: 200
base_model: meta-llama/Llama-2-7b
widget: text: ### Instruction:
Your task is to generate valid duckdb SQL to answer the following question.

### Input:

### Question:
create a new table called tmp from test.csv

### Response (use duckdb shorthand if possible):
example_title: read test.csv, text: ### Instruction:
Your task is to generate valid duckdb SQL to answer the following question.

### Input:

### Question:
create a new table called tmp from test.csv

### Response (use duckdb shorthand if possible):
example_title: get _amount columns, text: ### Instruction:
Your task is to generate valid duckdb SQL to answer the following question, given a duckdb database schema.

### Input:
Here is the database schema that the SQL query will run on:
CREATE TABLE rideshare (
    hvfhs_license_num varchar,
    dispatching_base_num varchar,
    originating_base_num varchar,
    request_datetime timestamp,
    on_scene_datetime timestamp,
    pickup_datetime timestamp,
    dropoff_datetime timestamp,
    trip_miles double,
    trip_time bigint,

);

### Question:
get longest trip in december 2022

### Response (use duckdb shorthand if possible):
example_title: taxi trips
Likes: 105 | All-time downloads: 52385
Created: 2024-01-24 19:13:56