### Database Schema:
CREATE TABLE Customers (
	CustomerID	INTEGER	NULL	PRIMARY KEY,
	`Customer Names`	TEXT	NULL
);

CREATE TABLE `Sales Orders` (
	OrderNumber	TEXT	NULL	PRIMARY KEY,
	`Sales Channel`	TEXT	NULL,
	WarehouseCode	TEXT	NULL,
	ProcuredDate	TEXT	NULL,
	OrderDate	TEXT	NULL,
	ShipDate	TEXT	NULL,
	DeliveryDate	TEXT	NULL,
	CurrencyCode	TEXT	NULL,
	_SalesTeamID	INTEGER	NULL,
	_CustomerID	INTEGER	NULL,
	_StoreID	INTEGER	NULL,
	_ProductID	INTEGER	NULL,
	`Order Quantity`	INTEGER	NULL,
	`Discount Applied`	REAL	NULL,
	`Unit Price`	TEXT	NULL,
	`Unit Cost`	TEXT	NULL,
	foreign key (_SalesTeamID) references `Sales Team` (SalesTeamID),
	foreign key (_ProductID) references Products (ProductID),
	foreign key (_CustomerID) references Customers (CustomerID),
	foreign key (_StoreID) references `Store Locations` (StoreID)
);

CREATE TABLE Products (
	ProductID	INTEGER	NULL	PRIMARY KEY,
	`Product Name`	TEXT	NULL
);

CREATE TABLE `Sales Team` (
	SalesTeamID	INTEGER	NULL	PRIMARY KEY,
	`Sales Team`	TEXT	NULL,
	Region	TEXT	NULL
);

CREATE TABLE `Store Locations` (
	StoreID	INTEGER	NULL	PRIMARY KEY,
	`City Name`	TEXT	NULL,
	County	TEXT	NULL,
	StateCode	TEXT	NULL,
	State	TEXT	NULL,
	Type	TEXT	NULL,
	Latitude	REAL	NULL,
	Longitude	REAL	NULL,
	AreaCode	INTEGER	NULL,
	Population	INTEGER	NULL,
	`Household Income`	INTEGER	NULL,
	`Median Income`	INTEGER	NULL,
	`Land Area`	INTEGER	NULL,
	`Water Area`	INTEGER	NULL,
	`Time Zone`	TEXT	NULL,
	foreign key (StateCode) references Regions (StateCode)
);

CREATE TABLE Regions (
	StateCode	TEXT	NULL	PRIMARY KEY,
	State	TEXT	NULL,
	Region	TEXT	NULL
);

### User's Query:
Please indicate total order quantity of product Candles and calculate the percentage of such product among all the orders.

### Extra Knowledge:
total order quantity refers to Sum (Order Quantity); 'Candles' is the Products Name; percentage = Divide (Sum(Order Quantity where Product Name = 'Candles'), Sum(Order Quantity)) * 100
SELECT SUM(CASE WHEN T1.`Product Name` = 'Candles' THEN T2.`Order Quantity` ELSE 0 END), CAST(SUM(CASE WHEN T1.`Product Name` = 'Candles' THEN T2.`Order Quantity` ELSE 0 END) AS REAL) * 100 / SUM(T2.`Order Quantity`) FROM Products AS T1 INNER JOIN `Sales Orders` AS T2 ON T2._ProductID = T1.ProductID INNER JOIN `Store Locations` AS T3 ON T3.StoreID = T2._StoreID