Spaces:
Runtime error
Runtime error
| <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> | |
| <!-- <h2>Text-to-SQL Example</h2>--> | |
| <!-- <iframe src="{{ url_for('send_examples', filename='htmls_Text2SQL/TP/test-0.html') }}"></iframe>--> | |
| <!-- <p>--> | |
| <!-- In this example, you can see how the SQL command directly addresses the statement by counting the number of games where the opposing team didn't score.--> | |
| <!-- </p>--> | |
| <button onclick="location.href='{{ url_for('experiment', session_id=session_id) }}'">Proceed to Experiment</button> | |
| </div> | |
| </body> | |
| </html> |