ItemsBought procedure SQL
DROP TABLE IF EXISTS items;
CREATE TABLE items (
id int 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');
/*
Finish the ItemsBought procedure so that it returns only items whose dateBought
is between @date and one month after @date (both inclusive).
For each item it should return:*/
GO
Alter PROCEDURE ItemsBought (@Date date) AS
BEGIN
DECLARE @Date2 date
SET @Date2 = Dateadd(Month, 1, @Date)
SELECT Day(dateBought) day, Month(dateBought) Month, name FROM items
where dateBought between @date and @date2
END;
GO
EXEC ItemsBought '2020-08-01'