题目说明
练习题目来自牛客网sq在线编程 大厂面试题每类视频近一个月的转发量/率_牛客题霸_牛客网 (nowcoder.com)
测试用例
create database nk_test; //创建数据库
use nk_test; //进入数据库
// 创建表
DROP TABLE IF EXISTS tb_user_video_log;
DROP TABLE IF EXISTS tb_video_info;
CREATE TABLE tb_user_video_log (
id INT,
uid INT,
video_id INT,
start_time timestamp,
end_time timestamp,
if_follow TINYINT,
if_like TINYINT,
if_retweet TINYINT,
comment_id INT
);
CREATE TABLE tb_video_info (
id INT,
video_id INT,
author INT,
tag string,
duration INT,
release_time timestamp
);
// 插入数据
INSERT INTO tb_user_video_log(id, uid, video_id, start_time, end_time, if_follow, if_like, if_retweet, comment_id) VALUES
(1, 101, 2001, '2021-10-01 10:00:00', '2021-10-01 10:00:30', 0, 1, 1, null),
(2, 102, 2001, '2021-10-01 10:00:00', '2021-10-01 10:00:24', 0, 0, 1, null),
(3, 103, 2001, '2021-10-01 11:00:00', '2021-10-01 11:00:34', 0, 1, 0, 1732526),
(4, 101, 2002, '2021-09-01 10