SQL sorcerer

Prompt

Transform the following natural language requests into valid SQL queries. Assume a database with the following tables and columns exists:
Customers:
customer_id (INT, PRIMARY KEY)
first_name (VARCHAR)
last_name (VARCHAR)
email (VARCHAR)
phone (VARCHAR)
address (VARCHAR)
city (VARCHAR)
state (VARCHAR)
zip_code (VARCHAR)
Products:
product_id (INT, PRIMARY KEY)
product_name (VARCHAR)
description (TEXT)
category (VARCHAR)
price (DECIMAL)
stock_quantity (INT)
Orders:
order_id (INT, PRIMARY KEY)
customer_id (INT, FOREIGN KEY REFERENCES Customers)
order_date (DATE)
total_amount (DECIMAL)
status (VARCHAR)
Order_Items:
order_item_id (INT, PRIMARY KEY)
order_id (INT, FOREIGN KEY REFERENCES Orders)
product_id (INT, FOREIGN KEY REFERENCES Products)
quantity (INT)
price (DECIMAL)
Reviews:
review_id (INT, PRIMARY KEY)
product_id (INT, FOREIGN KEY REFERENCES Products)
customer_id (INT, FOREIGN KEY REFERENCES Customers)
rating (INT)
comment (TEXT)
review_date (DATE)
Employees:
employee_id (INT, PRIMARY KEY)
first_name (VARCHAR)
last_name (VARCHAR)
email (VARCHAR)
phone (VARCHAR)
hire_date (DATE)
job_title (VARCHAR)
department (VARCHAR)
salary (DECIMAL)
Provide the SQL query that would retrieve the data based on the natural language request.

Sample query

Transform the following natural language requests into valid SQL queries. Assume a database with the following tables and columns exists:
Customers:
customer_id (INT, PRIMARY KEY)
first_name (VARCHAR)
last_name (VARCHAR)
email (VARCHAR)
phone (VARCHAR)
address (VARCHAR)
city (VARCHAR)
state (VARCHAR)
zip_code (VARCHAR)
Products:
product_id (INT, PRIMARY KEY)
product_name (VARCHAR)
description (TEXT)
category (VARCHAR)
price (DECIMAL)
stock_quantity (INT)
Orders:
order_id (INT, PRIMARY KEY)
customer_id (INT, FOREIGN KEY REFERENCES Customers)
order_date (DATE)
total_amount (DECIMAL)
status (VARCHAR)
Order_Items:
order_item_id (INT, PRIMARY KEY)
order_id (INT, FOREIGN KEY REFERENCES Orders)
product_id (INT, FOREIGN KEY REFERENCES Products)
quantity (INT)
price (DECIMAL)
Reviews:
review_id (INT, PRIMARY KEY)
product_id (INT, FOREIGN KEY REFERENCES Products)
customer_id (INT, FOREIGN KEY REFERENCES Customers)
rating (INT)
comment (TEXT)
review_date (DATE)
Employees:
employee_id (INT, PRIMARY KEY)
first_name (VARCHAR)
last_name (VARCHAR)
email (VARCHAR)
phone (VARCHAR)
hire_date (DATE)
job_title (VARCHAR)
department (VARCHAR)
salary (DECIMAL)
Provide the SQL query that would retrieve the data based on the natural language request.

Sample response

Retrieve the first and last names of all customers:

SELECT first_name, last_name
FROM Customers;

Retrieve the product names and prices of all products in the "Electronics" category:

SELECT product_name, price
FROM Products
WHERE category = 'Electronics';

Retrieve the total amount and status of all orders placed by customer with ID 123:

SELECT total_amount, status
FROM Orders
WHERE customer_id = 123;

Retrieve the product names and quantities ordered for all items in order with ID 456:

SELECT p.product_name, oi.quantity
FROM Order_Items oi
JOIN Products p ON oi.product_id = p.product_id
WHERE oi.order_id = 456;

Retrieve the average rating of all products:

SELECT AVG(rating) AS average_rating
FROM Reviews;

Retrieve the first and last names of employees hired after January 1, 2020:

SELECT first_name, last_name
FROM Employees
WHERE hire_date > '2020-01-01';