|
<!DOCTYPE html> |
|
<html> |
|
<head> |
|
<title>Text-to-SQL Explanations in TableQA</title> |
|
<style> |
|
body { |
|
font-family: 'Roboto', sans-serif; |
|
background: url('/api/placeholder/1920/1080') no-repeat center center fixed; |
|
background-size: cover; |
|
display: flex; |
|
justify-content: center; |
|
align-items: center; |
|
min-height: 100vh; |
|
margin: 0; |
|
padding: 20px; |
|
} |
|
.container { |
|
text-align: center; |
|
background-color: #ffffff; |
|
padding: 40px; |
|
border-radius: 10px; |
|
box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1); |
|
width: 80%; |
|
max-width: 1000px; |
|
} |
|
h1, h2 { |
|
color: #333; |
|
} |
|
p, li { |
|
font-size: 16px; |
|
color: #333; |
|
text-align: left; |
|
} |
|
.step { |
|
background-color: #f9f9f9; |
|
border: 1px solid #ddd; |
|
border-radius: 5px; |
|
margin-bottom: 20px; |
|
padding: 15px; |
|
} |
|
.step-title { |
|
font-weight: bold; |
|
margin-bottom: 10px; |
|
} |
|
table { |
|
width: 100%; |
|
border-collapse: collapse; |
|
margin-bottom: 20px; |
|
} |
|
th, td { |
|
border: 1px solid #ddd; |
|
padding: 8px; |
|
text-align: left; |
|
} |
|
th { |
|
background-color: #f2f2f2; |
|
} |
|
.highlighted-cell { |
|
background-color: #ffffcc; |
|
} |
|
button { |
|
background-color: #4CAF50; |
|
color: white; |
|
padding: 15px 30px; |
|
border: none; |
|
border-radius: 5px; |
|
cursor: pointer; |
|
font-size: 18px; |
|
transition: background-color 0.3s ease; |
|
margin-top: 20px; |
|
} |
|
button:hover { |
|
background-color: #45a049; |
|
} |
|
iframe { |
|
width: 100%; |
|
height: 600px; |
|
border: none; |
|
margin-top: 20px; |
|
} |
|
.sql-command { |
|
background-color: #f0f0f0; |
|
padding: 10px; |
|
border-left: 4px solid #4CAF50; |
|
font-family: monospace; |
|
white-space: pre-wrap; |
|
text-align: left; |
|
margin-bottom: 20px; |
|
} |
|
</style> |
|
</head> |
|
<body> |
|
<div class="container"> |
|
<h1>Understanding Text-to-SQL Explanations</h1> |
|
<p> |
|
Text-to-SQL is a TableQA method that translates the natural language question into an SQL query. The SQL query itself serves as the explanation for how the system arrives at its answer. |
|
</p> |
|
<h2>Example: 1947 Kentucky Wildcats Football Team</h2> |
|
<p> |
|
Statement to verify: "The Wildcats kept the opposing team scoreless in 4 games." |
|
</p> |
|
<div class="step"> |
|
<div class="step-title">SQL Command Generation</div> |
|
<p>The system generates an SQL command to verify the statement:</p> |
|
<div class="sql-command"> |
|
SELECT CASE |
|
WHEN COUNT(*) = 4 THEN 'TRUE' |
|
ELSE 'FALSE' |
|
END AS result |
|
FROM table_sql |
|
WHERE opponents = 0; |
|
</div> |
|
<p>This SQL command does the following:</p> |
|
<ol> |
|
<li>It counts the number of rows where the 'opponents' column is 0 (scoreless games).</li> |
|
<li>If the count is exactly 4, it returns 'TRUE', otherwise 'FALSE'.</li> |
|
</ol> |
|
</div> |
|
|
|
|
|
|
|
|
|
|
|
<button onclick="location.href='{{ url_for('experiment', session_id=session_id) }}'">Proceed to Experiment</button> |
|
</div> |
|
</body> |
|
</html> |
