Try the Sample: Count the total number of orders placed by each customer and show the results for customers who have placed more than 5 orders.
Samples you can try for Text to SQL Conversion
Sample 1: Natural Language to SQL
Input Text (Natural Language): “Select all columns from the ‘Customers’ table where the ‘Age’ is greater than 30.”
Explanation: This simple query selects all records from the Customers table where the Age is greater than 30.
Expected SQL Output:
SELECT *
FROM Customers
WHERE Age > 30;Sample 2: Natural Language to SQL
Input Text (Natural Language): “Show me the names and emails of all employees who joined after January 1st, 2020, ordered by joining date.”
Explanation: This query filters employees who joined after January 1st, 2020, and sorts the results by their JoinDate.
Expected SQL Output:
SELECT Name, Email
FROM Employees
WHERE JoinDate > '2020-01-01'
ORDER BY JoinDate;Sample 3: Natural Language to SQL
Input Text (Natural Language): “Count the total number of orders placed by each customer and show the results for customers who have placed more than 5 orders.”
Explanation: This query counts the total number of orders (OrderID) for each customer (CustomerID) and filters the results to only include customers who have placed more than 5 orders.
Expected SQL Output:
SELECT CustomerID, COUNT(OrderID) AS TotalOrders
FROM Orders
GROUP BY CustomerID
HAVING COUNT(OrderID) > 5;Sample 4: Natural Language to SQL
Input Text (Natural Language): “Find the average salary for each department where the salary is greater than 50,000.”
Explanation: This query calculates the average salary for each Department, considering only those employees whose salary is greater than 50,000.
Expected SQL Output:
SELECT Department, AVG(Salary) AS AverageSalary
FROM Employees
WHERE Salary > 50000
GROUP BY Department;Sample 5: Natural Language to SQL
Input Text (Natural Language): “List the product names and their prices from the ‘Products’ table where the price is between 100 and 500.”
Explanation: This query retrieves the product names (ProductName) and their prices (Price) from the Products table, filtering for products whose price is between 100 and 500.
Expected SQL Output:
SELECT ProductName, Price
FROM Products
WHERE Price BETWEEN 100 AND 500;These samples help you understand how to use our Text to SQL Converter tool. and How it can transform simple natural language queries into SQL queries for various scenarios, such as filtering, aggregation, and ordering data.