在MySQL中使用FIRST_VALUE()

I have 2 tables:个

CREATE TABLE `posts` (
  `帖子主题:回复:` int NOT NULL AUTO_INCREMENT,
  `author_id` int DEFAULT NULL,
  `text` text NOT NULL,
  `created` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`帖子主题:回复:`),
  KEY `fk_owner_user` (`author_id`),
  KEY `idx_帖子主题:回复:` (`帖子主题:回复:`),
  CONSTRAINT `fk_author_user` FOREIGN KEY (`author_id`) REFERENCES `users` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

and个

CREATE TABLE `Likes` (
    `like_id` int NOT NULL AUTO_INCREMENT,
    `user_id` INT DEFAULT NULL,
    `object_id` INT NOT NULL,
    `object_type_id` INT DEFAULT NULL, -- Посилання на тип об'єкта з таблиці "ObjectTypes".
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`like_id`),
    KEY `fk_like_type` (`object_type_id`),
    KEY `fk_like_user` (`user_id`),
    KEY `idx_like_id` (`like_id`),
    CONSTRAINT `fk_like_type` FOREIGN KEY (`object_type_id`) REFERENCES `ObjectTypes` (`type_id`) ON DELETE SET NULL ON UPDATE CASCADE,
    CONSTRAINT `fk_like_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) ON DELETE SET NULL ON UPDATE CASCADE
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

I'am trying to get:个

• 帖子主题:回复:
• 帖子正文
• 本帖第一个点赞的ID
• 这篇帖子上的第一个赞的日期时间
• 本帖最后一次点赞的ID
• 这篇帖子上最后一次喜欢的日期时间

My sql:个

SELECT
  p.帖子主题:回复:,
  p.text,
  FIRST_VALUE(l.like_id) OVER (PARTITION BY p.帖子主题:回复: ORDER BY l.created_at) AS first_like_id,
  FIRST_VALUE(l.created_at) OVER (PARTITION BY l.object_id ORDER BY created_at) AS first_like_time,
  LAST_VALUE(l.like_id) OVER (PARTITION BY p.帖子主题:回复: ORDER BY l.created_at) AS last_like_id,
  LAST_VALUE(l.created_at) OVER (PARTITION BY l.object_id ORDER BY created_at) AS last_like_time
FROM
  posts p
JOIN
  Likes l
ON
  p.帖子主题:回复: = l.object_id
ORDER BY  p.帖子主题:回复: DESC;

我得到的结果如下:

120 Impedit magni vero error ut.    72  2023-10-19 04:00:00 72  2023-10-19 04:00:00
119 At eum aut quibusdam ut.    1   2023-10-02 10:54:29 1   2023-10-02 10:54:29
119 At eum aut quibusdam ut.    1   2023-10-02 10:54:29 71  2023-10-19 03:15:00
119 At eum aut quibusdam ut.    1   2023-10-02 10:54:29 94  2023-10-04 11:54:29
119 At eum aut quibusdam ut.    1   2023-10-02 10:54:29 93  2023-10-03 12:00:29
118 Sequi dolor aut quis harum. 44  2023-10-03 10:49:20 70  2023-10-19 02:45:00
118 Sequi dolor aut quis harum. 44  2023-10-03 10:49:20 44  2023-10-03 10:49:20
117 Eos totam cum blanditiis.   27  2023-10-08 22:14:05 69  2023-10-19 01:30:00
117 Eos totam cum blanditiis.   27  2023-10-08 22:14:05 27  2023-10-08 22:14:05
116 Id quaerat quisquam quia.   15  2023-10-06 07:58:51 68  2023-10-19 00:00:00
116 Id quaerat quisquam quia.   15  2023-10-06 07:58:51 15  2023-10-06 07:58:51

例如，帖子主题:回复:=119的POST有4行. 如何获取唯一行的帖子主题:回复:？