-- Suggested testing environment:
-- https://rextester.com/l/sql_server_online_compiler with language set as SQL Server

-- Example case create statement:
CREATE TABLE items (
    id INTEGER NOT NULL PRIMARY KEY,
    name VARCHAR(30) NOT NULL,
    dateBought DATE NOT NULL
);

INSERT INTO items (id, name, dateBought) VALUES (0, 'Eggs', '2020-08-01');
INSERT INTO items (id, name, dateBought) VALUES (1, 'Couch', '2020-07-23');
INSERT INTO items (id, name, dateBought) VALUES (2, 'Potatoes', '2020-01-11');
INSERT INTO items (id, name, dateBought) VALUES (3, 'Llama', '2020-09-01');

GO
CREATE PROCEDURE ItemsBought (@date DATE) AS
BEGIN
  -- Write your code here
  SELECT * FROM items;
END;
GO

EXEC ItemsBought '2020-08-01'
-- Expected output:
-- day    month    name
----------------------
-- 1      8        Eggs
-- 1      9        Llama