Week 108 – Basic

DYNAMIC SQL!

Another new feature that, in my opinion, hasn’t had enough hype around it. Your task is to create the following table:

CREATE TABLE week_108 AS
SELECT * FROM VALUES
    (1, 'Alice', 'Laptop', 1, 1200.50),
    (2, 'Bob', 'Smartphone', 2, 800.00),
    (3, 'Charlie', 'Tablet', 1, 300.00),
    (4, 'David', 'Smartwatch', 3, 150.00),
    (5, 'Eva', 'Headphones', 2, 100.00),
    (6, 'Frank', 'Laptop', 1, 1300.00),
    (7, 'Grace', 'Smartphone', 1, 900.00),
    (8, 'Hank', 'Tablet', 4, 320.00),
    (9, 'Ivy', 'Smartwatch', 2, 180.00),
    (10, 'Jack', 'Headphones', 3, 110.00),
    (11, 'Karen', 'Laptop', 1, 1250.75),
    (12, 'Leo', 'Smartphone', 2, 850.00),
    (13, 'Mona', 'Tablet', 1, 350.00),
    (14, 'Nina', 'Smartwatch', 3, 160.00),
    (15, 'Oscar', 'Headphones', 2, 105.00),
    (16, 'Paul', 'Laptop', 1, 1350.00),
    (17, 'Quincy', 'Smartphone', 1, 950.00),
    (18, 'Rita', 'Tablet', 4, 330.00),
    (19, 'Sam', 'Smartwatch', 2, 200.00),
    (20, 'Tina', 'Headphones', 3, 115.00)
    AS sales(sale_id, customer_name, product_name, quantity, sale_amount);

And complete the following query:

SELECT *
FROM TABLE(
    TO_QUERY(
        SQL => '',
        <VARIABLE> => $<SOME_SESSION_VARIABLE_YOU_OUGHT_TO_CREATE>
    )
)

If the concept of session variables is a bit intimidating, read this page.