Model: TheBloke/sqlcoder-34b-alpha-GGUF
Author: TheBloke
Pipeline: text-generation
Library: transformers
Tags: transformers, gguf, llama, text-generation, en, base_model:defog/sqlcoder-34b-alpha, base_model:quantized:defog/sqlcoder-34b-alpha, license:cc-by-4.0, region:us
Base models (quantized): id: defog/sqlcoder-34b-alpha
Card metadata: base_model: defog/sqlcoder-34b-alpha
inference: no
language: en
license: cc-by-4.0
model_creator: Defog.ai
model_name: SQLCoder 34B Alpha
model_type: llama
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
Likes: 12 | All-time downloads: 9285
Created: 2023-11-18 17:35:50