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.
gaku_t says
my solution
mferle says
Good to know!