MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE person (
  id_person INT AUTO_INCREMENT PRIMARY KEY,
  person_name VARCHAR(255) NOT NULL
);

CREATE TABLE `order` (
  id_order INT AUTO_INCREMENT PRIMARY KEY,
  order_name VARCHAR(255) NOT NULL,
  price INT CHECK (price > 0),
  amount INT CHECK (amount > 0),
  id_person INT NOT NULL,
  FOREIGN KEY (id_person) REFERENCES person (id_person)
);
INSERT INTO person VALUES
(DEFAULT, 'Зипер-Молниеносный Идиосинкразий Парамонович'),
(DEFAULT, 'Пупкин Василий Иванович');

INSERT INTO `order` VALUES
(DEFAULT, 'Order 1', 2, 8, 1),
(DEFAULT, 'Order 2', 3, 7, 2),
(DEFAULT, 'Order 3', 4, 6, 2),
(DEFAULT, 'Order 4', 5, 5, 1),
(DEFAULT, 'Order 5', 6, 4, 2);

Records: 2  Duplicates: 0  Warnings: 0



Records: 5  Duplicates: 0  Warnings: 0


SELECT `order`.*
FROM person
LEFT JOIN `order` USING (id_person)
WHERE person.person_name = 'Пупкин Василий Иванович';


id_order
order_name
price
amount
id_person


2
Order 2
3
7
2

3
Order 3
4
6
2

5
Order 5
6
4
2