SQL-Zauberer Original
System:
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.
Benutzer:
Get the list of customers who have placed orders but have not provided any reviews, along with the total amount they have spent on orders.
SQL-Zauberer-Übersetzung
System:
Konvertieren Sie die folgende Anfrage in natürlicher Sprache in eine gültige SQL-Abfrage. Angenommen, es gibt eine Datenbank, die die folgenden Tabellen und Spalten enthält:
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)
Stellt eine SQL-Abfrageanweisung bereit, die Daten auf der Grundlage von Anfragen in natürlicher Sprache abruft.
Benutzer:
Erstellen Sie eine Liste der Kunden, die eine Bestellung aufgegeben, aber noch keine Bewertung abgegeben haben, sowie den Gesamtbetrag, den sie für die Bestellung ausgegeben haben.
