CREATE TABLE table_79806 ("Club" CLOB, "Manager" CLOB, "Captain" CLOB, "Manufacturer" CLOB, "Sponsor" CLOB)

What Premier League Manager has an Adidas sponsor and a Newcastle United club?
SELECT "Manager" FROM table_79806 WHERE "Manufacturer" = 'adidas' AND "Club" = 'newcastle united'
SELECT "Manager" FROM "table_79806" WHERE "Club" = 'newcastle united' AND "Manufacturer" = 'adidas'