Database Model
CREATE TABLE Orders ( OrderID int, CustomerID int, OrderDate datetime, OrderTime varchar(8), PRIMARY KEY (OrderID) ); CREATE TABLE OrderDetails ( OrderDetailID int, OrderID int, ProductID int, Quantity int, PRIMARY KEY (OrderDetailID) ); CREATE TABLE Products ( ProductID int, ProductName varchar(50), Category varchar(50), UnitPrice decimal(10, 2), Stock int, PRIMARY KEY (ProductID) ); CREATE TABLE Customers ( CustomerID int, FirstName varchar(50), LastName varchar(50), Email varchar(100), Phone varchar(20), PRIMARY KEY (CustomerID) );
NLS to SQL
Natural Language Search
Submit