Model: motherduckdb/DuckDB-NSQL-7B-v0.1-GGUF
Author: motherduckdb
Tags: gguf, license:llama2, endpoints_compatible, region:us
Card metadata: license: llama2
inference: parameters: do_sample: no
max_length: 200
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: 23 | All-time downloads: 3675
Created: 2024-01-24 19:31:51