MySQL 5.7

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

CREATE TABLE `client` (
  `id` INT UNSIGNED AUTO_INCREMENT NOT NULL, 
  `name` VARCHAR(255) DEFAULT NULL, 
  `surname` VARCHAR(255) DEFAULT NULL, 
  `order` INT DEFAULT NULL, 
  PRIMARY KEY(`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB;

insert into `client` (`name`, `surname`, `order`) 
values 
  ('Vinny', 'Rad', 2);

insert into `client` (`name`, `surname`, `order`) 
values 
  ('Zoe', 'Hansen', 1);

CREATE TABLE `invoice` (
  `id` INT UNSIGNED AUTO_INCREMENT NOT NULL, 
  `client_id` INT DEFAULT NULL, 
  `name` VARCHAR(255) DEFAULT NULL, 
  `amount` DOUBLE PRECISION DEFAULT NULL, 
  PRIMARY KEY(`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB;

insert into `invoice` (`client_id`, `name`, `amount`) 
values 
  (1, 'chair purchase', 4);

insert into `invoice` (`client_id`, `name`, `amount`) 
values 
  (1, 'table purchase', 15);

insert into `invoice` (`client_id`, `name`, `amount`) 
values 
  (2, 'chair purchase', 4);

select 
  (
    select 
      `name` 
    from 
      (
        select 
          `id`, 
          `name`, 
          `surname`, 
          `order` 
        from 
          `client`
      ) `_c_2bfe9d72a4aa` 
    where 
      `id` = `__inner__`.`client_id`
  ) `client`, 
  `client_id`, 
  sum(`amount`) `amount` 
from 
  (
    select 
      `id`, 
      `name`, 
      `client_id`, 
      `amount` 
    from 
      `invoice`
  ) `__inner__` 
group by 
  `client_id` 
having 
  (
    `client_id` = 2
    and sum(`amount`) > 3.9
    and sum(`amount`) < 4.1
  );

client	client_id	amount
Zoe	2	4