Most Advanced AI

To generate SQL, please enter the information about tables and columns. After that you should give details in plain English what information you want from the tables. First you should give Table <table_name>, then columns = [<colum_1>, <colum_2>, <colum_3>, ...]. It is not necessary to give all the column names, giving relevant column names will do. However, if you enter all the column names, that is also fine. It is mandatory to put one blank line after the table description.

Below we give some examples:

Example 1:
Table employees, columns = [employee_id, employee_name, employee_salary]

Get the name and salary of the top 10 employees. This should be sorted in descending order of salary.

Example 2:
Table departments, columns = [department_id, department_name, country_id, country_name]
Table employees, columns = [employee_id, employee_name, employee_salary, department_id]

Get the name of the departments which employ more than 20 employees and the average salary of the employees in that department is more than 20,000.

Example 3:
Table departments, columns = [department_id, department_name, country_id, country_name]
Table employees, columns = [employee_id, employee_name, employee_salary, department_id]

Get the employee name, salary and department name of the top 15 employees whose salary is the highest.

Example 4:
Table employees, columns = [employee_id, employee_name, employee_salary, department_id]

Display name and salary of the employee who is getting second highest salary.

You have not logged in.
Please login by clicking on the link: Login