CREATE TABLE manufacturers (code NUMBER, name CLOB, headquarter CLOB, founder CLOB, revenue NUMBER)
CREATE TABLE products (code NUMBER, name CLOB, price NUMBER, manufacturer NUMBER)

Select the name and price of the cheapest product.
SELECT name, price FROM products ORDER BY price LIMIT 1
SELECT "name", "price" FROM "products" ORDER BY "price" FETCH FIRST 1 ROWS ONLY