Model: bugdaryan/MistralSQL-7b
Author: bugdaryan
Pipeline: text-generation
Library: transformers
Tags: transformers, pytorch, mistral, text-generation, text2sql, conversational, en, dataset:bugdaryan/sql-create-context-instruction, license:apache-2.0, text-generation-inference, endpoints_compatible, region:us
Card metadata: license: apache-2.0
datasets: bugdaryan/sql-create-context-instruction
language: en
tags: text2sql
widget: text: 
 Write SQLite query to answer the following question given the database schema. Please wrap your code answer using ```: Schema: CREATE TABLE head (age INTEGER) Question: How many heads of the departments are older than 56 ? 
 Here is the SQLite query to answer to the question: How many heads of the departments are older than 56 ?: ```
example_title: Example 1, text: 
 Write SQLite query to answer the following question given the database schema. Please wrap your code answer using ```: Schema: CREATE TABLE people (first_name VARCHAR) Question: List the first names of people in alphabetical order? 
 Here is the SQLite query to answer to the question: List the first names of people in alphabetical order?: ```
example_title: Example 2, text: 
 Write SQLite query to answer the following question given the database schema. Please wrap your code answer using ```: Schema: CREATE TABLE weather (zip_code VARCHAR, mean_sea_level_pressure_inches INTEGER) Question: What is the zip code in which the average mean sea level pressure is the lowest? 
 Here is the SQLite query to answer to the question: What is the zip code in which the average mean sea level pressure is the lowest?: ```
example_title: Example 3, text: 
 Write SQLite query to answer the following question given the database schema. Please wrap your code answer using ```: Schema: CREATE TABLE weather (date VARCHAR, mean_temperature_f VARCHAR, mean_humidity VARCHAR, max_gust_speed_mph VARCHAR) Question: What are the date, mean temperature and mean humidity for the top 3 days with the largest max gust speeds? 
 Here is the SQLite query to answer to the question: What are the date, mean temperature and mean humidity for the top 3 days with the largest max gust speeds?: ```
example_title: Example 4, text: 
 Write SQLite query to answer the following question given the database schema. Please wrap your code answer using ```: Schema: CREATE TABLE trip (end_station_id VARCHAR); CREATE TABLE station (id VARCHAR, city VARCHAR) Question: Count the number of trips that did not end in San Francisco city. 
 Here is the SQLite query to answer to the question: Count the number of trips that did not end in San Francisco city.: ```
example_title: Example 5
Likes: 5 | All-time downloads: 1193
Created: 2023-10-08 08:09:34