CREATE TABLE manufacturer (manufacturer_id DECIMAL, open_year DECIMAL, name TEXT, num_of_factories DECIMAL, num_of_shops DECIMAL)
CREATE TABLE furniture_manufacte (manufacturer_id DECIMAL, furniture_id DECIMAL, price_in_dollar DECIMAL)
CREATE TABLE furniture (furniture_id DECIMAL, name TEXT, num_of_component DECIMAL, market_rate DECIMAL)

Give me the name and year of opening of the manufacturers that have either less than 10 factories or more than 10 shops.
SELECT name, open_year FROM manufacturer WHERE num_of_shops > 10 OR num_of_factories < 10
SELECT "name", "open_year" FROM "manufacturer" WHERE "num_of_factories" < 10 OR "num_of_shops" > 10