-- Database schema
| customers : CustomerID [ INTEGER ] primary_key , First [ TEXT ] , Last [ TEXT ] , StreetAddress [ TEXT ] , City [ TEXT ] , State [ TEXT ] , ZipCode [ INTEGER ] , Email [ TEXT ] , PhoneNumber [ TEXT ] , FirstPurchaseDate [ DATE ] , SubscribedToEmailList [ TEXT ] , Gender [ TEXT ] | geolocation : LocationID [ INTEGER ] primary_key geolocation.LocationID = location.LocationID , Latitude [ REAL ] , Longitude [ REAL ] | location : LocationID [ INTEGER ] primary_key location.LocationID = geolocation.LocationID , LocationName [ TEXT ] , StreetAddress [ TEXT ] , City [ TEXT ] , State [ TEXT ] , ZipCode [ INTEGER ] | rootbeerbrand : BrandID [ INTEGER ] primary_key , BrandName [ TEXT ] , FirstBrewedYear [ INTEGER ] , BreweryName [ TEXT ] , City [ TEXT ] , State [ TEXT ] , Country [ TEXT ] , Description [ TEXT ] , CaneSugar [ TEXT ] , CornSyrup [ TEXT ] , Honey [ TEXT ] , ArtificialSweetener [ TEXT ] , Caffeinated [ TEXT ] , Alcoholic [ TEXT ] , AvailableInCans [ TEXT ] , AvailableInBottles [ TEXT ] , AvailableInKegs [ TEXT ] , Website [ TEXT ] , FacebookPage [ TEXT ] , Twitter [ TEXT ] , WholesaleCost [ REAL ] , CurrentRetailPrice [ REAL ] | rootbeer : RootBeerID [ INTEGER ] primary_key , BrandID [ INTEGER ] rootbeer.BrandID = rootbeerbrand.BrandID , ContainerType [ TEXT ] , LocationID [ INTEGER ] rootbeer.LocationID = geolocation.LocationID , PurchaseDate [ DATE ] | rootbeerreview : CustomerID [ INTEGER ] rootbeerreview.CustomerID = customers.CustomerID , BrandID [ INTEGER ] rootbeerreview.BrandID = rootbeerbrand.BrandID , StarRating [ INTEGER ] , ReviewDate [ DATE ] , Review [ TEXT ] | transaction : TransactionID [ INTEGER ] primary_key , CreditCardNumber [ INTEGER ] , CustomerID [ INTEGER ] transaction.CustomerID = customers.CustomerID , TransactionDate [ DATE ] , CreditCardType [ TEXT ] , LocationID [ INTEGER ] transaction.LocationID = location.LocationID , RootBeerID [ INTEGER ] transaction.RootBeerID = rootbeer.RootBeerID , PurchasePrice [ REAL ] |
-- -- Among the root beer brands that do not advertise on Facebook and Twitter, which brand has the highest number of purchases?

SELECT T2.BreweryName FROM rootbeer AS T1 INNER JOIN rootbeerbrand AS T2 ON T1.BrandID = T2.BrandID WHERE T2.FacebookPage IS NULL AND T2.Twitter IS NULL GROUP BY T2.BrandID ORDER BY COUNT(T1.BrandID) DESC LIMIT 1;