CREATE TABLE products (code DECIMAL, name TEXT, price DECIMAL, manufacturer DECIMAL)
CREATE TABLE manufacturers (code DECIMAL, name TEXT, headquarter TEXT, founder TEXT, revenue DECIMAL)

Select the names and the prices of all the products in the store.
SELECT name, price FROM products
SELECT "name", "price" FROM "products"