| | <!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> |
