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