CREATE TABLE STATS (
        STAT_ID INT(11) AUTO_INCREMENT PRIMARY KEY,
        STAT_DATE DATETIME NOT NULL,
        STAT VARCHAR(20) NOT NULL,
        VALUE INT(11) NOT NULL
    );
    

CREATE VIEW BESTSELLERS_COUNT AS
SELECT COUNT(BESTSELLER) FROM BOOKS
WHERE BESTSELLER = 1;

USE KODILLA_COURSE;

DELIMITER $$

CREATE EVENT UPDATE_STATS
	ON SCHEDULE EVERY 1 DAY
    DO BEGIN
    CALL UpdateBestSellers();
    INSERT INTO STATS(STAT, VALUE)
	VALUES("BESTSELLERS", COUNT(BESTSELLER));
    END $$
    
DELIMITER ;