MySQL 8.0

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

select version();

version()

8.0.23

CREATE TABLE test (id SERIAL PRIMARY KEY, val INT);
INSERT INTO test (val) VALUES
(1), (22), (333);
SELECT * FROM test;

id
val

1
1

2
22

3
333

SELECT MAX(id) max_id, SUM(val) sum_val
FROM test;

max_id
sum_val

3
356