query.sql

Generating SQL…

Understanding your request…

-- Press Ctrl+Enter or the Run button to execute.

SELECT
  s.name,
  s.grade,
  s.email,
  d.department_name,
  d.hod
FROM students s
JOIN departments d ON s.dept_id = d.id
WHERE s.grade >= 75
ORDER BY s.grade DESC;

Schema is prepended automatically before your query runs

No tables defined yet Add CREATE TABLE to the Schema tab

SQL · SQLite

1 line

Ln 1, Col 1

UTF-8

Terminal

● Connected

Press Run or Ctrl+Enter to execute your SQL.

AI Explanation

AI Off

gpt-4o

Loading…