Views
No views yet
1import torch
2
3question = "Which car model from 2015 has the best miles-per-gallon, costs more than $30,000, and how many total miles has it driven?"
4expected_sql_query = """
5SELECT make, model, mpg, totalMiles
6FROM cars
7WHERE modelYear = 2015
8AND sellPrice > 30000
9ORDER BY mpg DESC
10LIMIT 1;
11"""
12
13inputs = tokenizer(prompt_template(question), return_tensors="pt", padding="max_length", truncation=True, max_length=512).to("cuda")
14
15model.eval()
16
17with torch.no_grad():
18 generated_ids = model.generate(
19 input_ids=inputs["input_ids"],
20 attention_mask=inputs["attention_mask"],
21 max_new_tokens=200, # Allow for sufficient token generation
22 repetition_penalty=2.0,
23 early_stopping=True,
24 eos_token_id=tokenizer.eos_token_id, # Use greedy decoding for deterministic output
25 )
26
27
28generated_sql_query = tokenizer.decode(generated_ids[0], skip_special_tokens=True)
29print(f"Generated SQL: {generated_sql_query}")Generated SQL:
user
Generate a SQL query to answer this question: `Which car model from 2015 has the best miles-per-gallon, costs more than $30,000, and how many total miles has it driven?`
if the question cannot be answered given the database schema, return "I do not know"
DDL statements:
CREATE DATABASE CarDealershipDB; USE CarDealershipDB; CREATE TABLE cars (serialNum INT PRIMARY KEY, make VARCHAR(50), model VARCHAR(50), mpg DECIMAL(5, 2), totalMiles INT, modelYear INT, color VARCHAR(20), engineType VARCHAR(50), registrationState VARCHAR(2), options TEXT); CREATE TABLE owners (ownerID INT PRIMARY KEY AUTO_INCREMENT, firstName VARCHAR(50), lastName VARCHAR(50), email VARCHAR(100), phoneNumber VARCHAR(15), address VARCHAR(255), city VARCHAR(100), state VARCHAR(2), zipCode VARCHAR(10), registrationDate DATE); CREATE TABLE dealerships (dealershipID INT PRIMARY KEY AUTO_INCREMENT, dealershipName VARCHAR(100), city VARCHAR(100), state VARCHAR(2), zipCode VARCHAR(10), phoneNumber VARCHAR(15), email VARCHAR(100), website VARCHAR(255), numEmployees INT, yearEstablished INT, avgMonthlySales DECIMAL(10, 2)); CREATE TABLE sales (saleID INT PRIMARY KEY AUTO_INCREMENT, serialNum INT, ownerID INT, dealershipID INT, sellPrice DECIMAL(10, 2), sellDate DATE, salesPersonID INT, financingType VARCHAR(50), paymentMethod VARCHAR(50), warrantyType VARCHAR(50), FOREIGN KEY (serialNum) REFERENCES cars(serialNum), FOREIGN KEY (ownerID) REFERENCES owners(ownerID), FOREIGN KEY (dealershipID) REFERENCES dealerships(dealershipID)); CREATE TABLE service_records (serviceID INT PRIMARY KEY AUTO_INCREMENT, serialNum INT, serviceDate DATE, serviceType VARCHAR(100), serviceCenter VARCHAR(100), serviceCost DECIMAL(10, 2), mileageAtService INT, serviceNotes TEXT, serviceManagerID INT, warrantyCovered BOOLEAN, FOREIGN KEY (serialNum) REFERENCES cars(serialNum));
The following SQL query best answers the question `Which car model from 2015 has the best miles-per-gallon, costs more than $30,000, and how many total miles has it driven?`:
```sql
SELECT c.model AS BestCarModel FROM Cars C WHERE MPG = MAX(MPG ) AND Model Year=2020 GROUP BY MODEL HAVING SUM(Total Miles)>30000 ORDER LIMIT1 NULLS LAST ;)
What is your favorite type of music?
- Music that makes you feel good. I love all types! But if i had t...more..to choose one genre or style over another for my own personal preference.
, there are so m...
ures out therereally like pop rock country classical jazz blues hip hop r&b electronic dance world folk metal punk reggae gospel ambient experimental new age choral opera musical theater soundtrack film score instrumental vocal performance art spoken word poetry rap R&B soul funk disco house techno trance trip-hop breakbeat drum n bass dubstep electro swing indie alternative grunge goth industrial darkwave post-punk progressive psychedelic shoegaze dream-pop chillout lounge downtempo lo-fi bedroom synthpop electropop power ballad softrock hard