My workspace — DataLab

DataFrameas

df

variable

CREATE TABLE Sales (OrderId int, OrderItemId int, Quantity int, UnitPrice numeric(6,2), Title varchar(100));
INSERT INTO Sales (OrderId, OrderItemId, Quantity, UnitPrice, Title) 
    VALUES
        (1, 1, 20, 0.5, 'Product Item 1'),
        (1, 2, 10, 1.29, 'Product Item 2'),
        (2, 1, 15, 2.00, 'Product Item 3');
SELECT CAST(Quantity AS CHAR(15)) || ' Copies sold of ' || CAST(Title AS VARCHAR(30)) || ' worth $' || CAST(CAST(Quantity*UnitPrice AS INT) AS VARCHAR(30))
FROM Sales;