gpt4 book ai didi

Mysql 查询 : find the most checkout person on library?

转载 作者:行者123 更新时间:2023-12-01 00:35:03 24 4
gpt4 key购买 nike

<分区>

我有下表,其中包含以下项目

CREATE TABLE IF NOT EXISTS `lib_transactions` (
`transaction_id` int(11) NOT NULL,
`person` varchar(60) NOT NULL,
`isbn` varchar(20) NOT NULL,
`action` varchar(20) NOT NULL,
`timestamp` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=205 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `lib_transactions`
--

INSERT INTO `lib_transactions` (`transaction_id`, `person`, `isbn`, `action`, `timestamp`) VALUES
(186, '1', '99-9263-544-4', 'check-out', 1483228800),
(187, '2', '99-9263-544-5', 'check-out', 1483229100),
(188, '1', '99-9263-544-4', 'check-in', 1483315200),
(189, '2', '99-9263-544-5', 'check-in', 1483661100),
(190, '3', '99-9263-544-4', 'check-out', 1483747500),
(191, '2', '99-9263-544-6', 'check-out', 1483833900),
(192, '2', '99-9263-544-6', 'check-in', 1483920300),
(193, '3', '99-9263-544-7', 'check-out', 1484006700),
(194, '3', '99-9263-544-8', 'check-out', 1484100300),
(195, '3', '99-9263-544-7', 'check-in', 1484453100),
(196, '3', '99-9263-544-8', 'check-in', 1484460300),
(197, '4', '99-9263-544-7', 'check-out', 1484553900),
(198, '4', '99-9263-544-8', 'check-out', 1484611500),
(199, '4', '99-9263-544-7', 'check-in', 1484705100),
(200, '4', '99-9263-543-8', 'check-in', 1484798700),
(201, '5', '99-9263-543-1', 'check-out', 1484798700),
(202, '5', '99-9263-544-2', 'check-out', 1484798700),
(203, '5', '99-9263-542-3', 'check-out', 1484798700),
(204, '5', '99-9263-541-4', 'check-out', 1484798700);

如何实现以下查询:

- 目前谁拥有最多的书?

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com