MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SET SESSION sql_mode = '';
select @@version;


@@version


8.0.36


CREATE TABLE `questions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `other` varchar(10) NOT NULL,
  `asker` varchar(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_asker` (`asker`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4 ;
INSERT INTO `questions` (`id`, `other`, `asker`) VALUES
(1, '1st', 'Bob'),
(2, '2nd', 'Bob'),
(3, '3rd', 'Marley');

Records: 3  Duplicates: 0  Warnings: 0


SELECT * FROM questions GROUP BY asker ORDER BY asker DESC;


id
other
asker


3
3rd
Marley

2
2nd
Bob