SQLGenius - SQL Query Generation

Example

SELECT * FROM orders WHERE order_date >= '2023-01-01' AND order_date <= '2023-01-31';

Scenario

A user needs to retrieve all orders from January 2023. SQLGenius generates the query by understanding the date filter requirement.

Example

SELECT customer_id, SUM(total_amount) FROM orders GROUP BY customer_id;

Scenario

To analyze sales data, a user wants to know the total amount spent by each customer. SQLGenius crafts a query that sums up total sales per customer, grouping the results by customer ID.

Example

SELECT orders.order_id, customers.name FROM orders INNER JOIN customers ON orders.customer_id = customers.id;

Scenario

A user intends to view all orders along with customer names. SQLGenius formulates a join query that links the 'orders' table with the 'customers' table, matching on customer ID.

Example

SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';

Scenario

A developer needs to list all tables in a PostgreSQL database's 'public' schema. SQLGenius generates a query to access the database's schema information efficiently.