汉得信息 笔试 编程题个人答案

import java.util.Scanner;

public class Main {
    public static void main(String[] args) {
        Scanner in = new Scanner(System.in);
        long N = in.nextLong();
        long sum = 1;
        for (int i = 0; i < N; i++) {
            long M = in.nextLong();
            sum *= M;
            if (sum >= 1_0000_0000) {
                System.out.println("TLE");
                return;
            }
        }
        System.out.println(sum);
    }
}

# 这里是样例数据，答案在最下面

drop table if exists `info_tb`;
CREATE TABLE `info_tb`
(
    `info_id`    int(11)    NOT NULL,
    `info_l`     varchar(8) NOT NULL,
    `info_pv`    int(16)    NOT NULL,
    `praise_num` int(16)    NOT NULL,
    PRIMARY KEY (`info_id`)
);
INSERT INTO info_tb
VALUES (1, '军事', 256, 45);
INSERT INTO info_tb
VALUES (2, '体育', 156, 23);
INSERT INTO info_tb
VALUES (3, '军事', 234, 35);
INSERT INTO info_tb
VALUES (4, '娱乐', 572, 160);
INSERT INTO info_tb
VALUES (5, '政要', 278, 45);
INSERT INTO info_tb
VALUES (6, '体育', 450, 130);

drop table if exists `put_action_tb`;
CREATE TABLE `put_action_tb`
(
    `put_info_id` int(11)  NOT NULL,
    `put_author`  int(16)  NOT NULL,
    `put_time`    datetime NOT NULL,
    PRIMARY KEY (`put_info_id`)
);
INSERT INTO put_action_tb
VALUES (1, 101, '2022-02-18 08:30:00');
INSERT INTO put_action_tb
VALUES (2, 102, '2022-02-18 08:31:00');
INSERT INTO put_action_tb
VALUES (3, 101, '2022-02-18 08:42:00');
INSERT INTO put_action_tb
VALUES (4, 103, '2022-02-18 09:33:00');
INSERT INTO put_action_tb
VALUES (5, 101, '2022-02-18 16:34:00');
INSERT INTO put_action_tb
VALUES (6, 104, '2022-02-18 10:35:00');

drop table if exists `author_tb`;
CREATE TABLE `author_tb`
(
    `author_id`   int(11)    NOT NULL,
    `author_name` varchar(8) NOT NULL,
    `fans_num`    int(16)    NOT NULL,
    PRIMARY KEY (`author_id`)
);
INSERT INTO author_tb
VALUES (101, 'Aran', 1000);
INSERT INTO author_tb
VALUES (102, 'James', 500);
INSERT INTO author_tb
VALUES (103, 'Bill', 3000);
INSERT INTO author_tb
VALUES (104, 'Angel', 3000);

# 下面是答案

select author_name,
       sum(info_pv)    pv_nums,
       sum(praise_num) praise_nums
from author_tb
         join put_action_tb on author_id = put_author
         join info_tb on info_id = put_info_id
group by author_name
order by author_name;