Model: tensorblock/DuckDB-NSQL-7B-v0.1-GGUF
Author: tensorblock
Tags: gguf, TensorBlock, GGUF, base_model:motherduckdb/DuckDB-NSQL-7B-v0.1, base_model:quantized:motherduckdb/DuckDB-NSQL-7B-v0.1, license:llama2, endpoints_compatible, region:us
Base models (quantized): id: motherduckdb/DuckDB-NSQL-7B-v0.1
Card metadata: license: llama2
inference: parameters: do_sample: no
max_length: 200
base_model: motherduckdb/DuckDB-NSQL-7B-v0.1
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
tags: TensorBlock, GGUF
Likes: 1 | All-time downloads: 1580
Created: 2024-12-27 17:27:20