Model: TheBloke/sqlcoder2-GGUF
Author: TheBloke
Pipeline: text-generation
Library: transformers
Tags: transformers, gguf, starcoder, code, text-generation, en, base_model:defog/sqlcoder2, base_model:quantized:defog/sqlcoder2, license:other, region:us
Base models (quantized): id: defog/sqlcoder2
Card metadata: base_model: defog/sqlcoder2
inference: no
language: en
license: other
model_creator: Defog.ai
model_name: Sqlcoder2
model_type: starcoder
pipeline_tag: text-generation
prompt_template: ## Task
Generate a SQL query to answer the following question:
`{prompt}`

### Database Schema
This query will run on a database whose schema is represented in this string:
CREATE TABLE products (
  product_id INTEGER PRIMARY KEY, -- Unique ID for each product
  name VARCHAR(50), -- Name of the product
  price DECIMAL(10,2), -- Price of each unit of the product
  quantity INTEGER  -- Current quantity in stock
);

CREATE TABLE sales (
  sale_id INTEGER PRIMARY KEY, -- Unique ID for each sale
  product_id INTEGER, -- ID of product sold
  customer_id INTEGER,  -- ID of customer who made purchase
  salesperson_id INTEGER, -- ID of salesperson who made the sale
  sale_date DATE, -- Date the sale occurred
  quantity INTEGER -- Quantity of product sold
);

-- sales.product_id can be joined with products.product_id

### SQL
Given the database schema, here is the SQL query that answers `{prompt}`:
```sql

quantized_by: TheBloke
tags: code
Likes: 28 | All-time downloads: 14572
Created: 2023-10-10 13:11:17