Cannot chain with statements in SQL Lite.

Code:

%%sql WITH MAX as (SELECT Stores.Store, sum(Sales.WeeklySales) as salesSum FROM Stores, Sales, Holidays WHERE Stores.Store = Sales.Store and Sales.WeekDate = Holidays.WeekDate and Holidays.IsHoliday = 'TRUE' GROUP BY Stores.Store) SELECT MAX.Store, round(max(MAX.salesSum),2) AS AllSales FROM MAX UNION WITH MIN as (SELECT Stores.Store, sum(Sales.WeeklySales) as salesSum FROM Stores, Sales, Holidays WHERE Stores.Store = Sales.Store and Sales.WeekDate = Holidays.WeekDate and Holidays.IsHoliday = 'TRUE' GROUP BY Stores.Store) SELECT MIN.Store, round(MIN(MAX.salesSum),2) AS AllSales FROM MIN

Error:

(sqlite3.OperationalError) near "WITH": syntax error [SQL: WITH MAX as (SELECT Stores.Store, sum(Sales.WeeklySales) as salesSum FROM Stores, Sales, Holidays WHERE Stores.Store = Sales.Store and Sales.WeekDate = Holidays.WeekDate and Holidays.IsHoliday = 'TRUE' GROUP BY Stores.Store) SELECT MAX.Store, round(max(MAX.salesSum),2) AS AllSales FROM MAX UNION WITH MIN as (SELECT Stores.Store, sum(Sales.WeeklySales) as salesSum FROM Stores, Sales, Holidays WHERE Stores.Store = Sales.Store and Sales.WeekDate = Holidays.WeekDate and Holidays.IsHoliday = 'TRUE' GROUP BY Stores.Store) SELECT MIN.Store, round(MIN(MAX.salesSum),2) AS AllSales FROM MIN] (Background on this error at: http://sqlalche.me/e/e3q8)