SQLize Online / PHPize Online  /  SQLtest Online

DROP TABLE IF EXISTS `User`; CREATE TABLE IF NOT EXISTS `User` ( `id` int(11) NOT NULL AUTO_INCREMENT, `Registration_MonthDate` int(11) NOT NULL, `Acquisition_source` varchar(255) NOT NULL, `User_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `User_id` (`User_id`) ); INSERT INTO `User` ( `id`, `Registration_MonthDate`, `Acquisition_source`, `User_id` ) VALUES (1, 1, "Google", 12), (2, 1, "Facebook", 13), (3, 1, "Google", 15), (4, 2, "Google", 16), (5, 2, "Google", 14), (6, 3, "Google", 17), (7, 3, "Facebook", 18), (8, 3, "Facebook", 19), (9, 3, "Facebook", 20), (10, 3, "Google", 21), (11, 5, "Google", 22), (12, 5, "Facebook", 23), (13, 5, "Google", 24), (14, 5, "Google", 25); DROP TABLE IF EXISTS `Monthly_Acquisition_cost`; CREATE TABLE IF NOT EXISTS `Monthly_Acquisition_cost` ( `id` int(11) NOT NULL AUTO_INCREMENT, `MonthDate` int(11) DEFAULT NULL, `Acquisition_source` varchar(255) NOT NULL, `Cost` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ); INSERT INTO `Monthly_Acquisition_cost` ( `id`, `MonthDate`, `Acquisition_source`, `Cost` ) VALUES (1, 1, "Google", 1000), (2, 2, "Google", 1050), (3, 3, "Google", 950), (4, 4, "Google", 1200), (5, 5, "Google", 1500), (6, 1, "Facebook", 1000), (7, 2, "Facebook", 1050), (8, 3, "Facebook", 950), (9, 4, "Facebook", 1200), (10, 5, "Facebook", 1500); DROP TABLE IF EXISTS `Monthly_user_revenue`; CREATE TABLE IF NOT EXISTS `Monthly_user_revenue` ( `id` int(11) NOT NULL AUTO_INCREMENT, `MonthDate` int(11) NOT NULL, `User_id` int(11) NOT NULL, `Revenue` decimal(10, 4) DEFAULT NULL, PRIMARY KEY (`id`), KEY `User_id` (`User_id`) ); INSERT INTO `Monthly_user_revenue` ( `id`, `MonthDate`, `User_id`, `Revenue` ) VALUES (1, 1, 12, 1000), (2, 2, 12, 1000), (3, 3, 12, 1000), (4, 4, 12, 1000), (5, 1, 14, 1000), (6, 2, 14, 1000), (7, 3, 14, 1000), (8, 4, 14, 1000), (9, 1, 15, 1000), (10, 2, 15, 1000), (11, 3, 15, 1000), (12, 4, 15, 1000), (13, 5, 15, 1000), (14, 1, 16, 1000), (15, 2, 16, 1000), (16, 3, 16, 1000), (17, 4, 16, 1000), (18, 5, 16, 1000), (19, 1, 17, 1000), (20, 2, 17, 1000), (21, 3, 17, 1000), (22, 4, 17, 1000), (23, 5, 17, 1000), (24, 1, 18, 1000), (25, 2, 18, 1000), (26, 3, 18, 1000), (27, 4, 18, 1000), (28, 1, 19, 1000), (30, 2, 19, 1000), (31, 3, 19, 1000), (32, 4, 19, 1000), (33, 5, 19, 1000), (34, 1, 20, 1000), (35, 2, 20, 1000); COMMIT;