MySQL 8.0

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

DROP DATABASE IF EXISTS shop;
CREATE DATABASE shop CHARACTER SET utf8mb4;
USE shop;

CREATE TABLE manufacturer (
  id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100) NOT NULL
);

CREATE TABLE product (
  id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  price DOUBLE NOT NULL,
  manufacturer_id INT UNSIGNED NOT NULL,
  FOREIGN KEY (manufacturer_id) REFERENCES manufacturer(id)
);

INSERT INTO manufacturer VALUES(1, 'Asus');
INSERT INTO manufacturer VALUES(2, 'Lenovo');
INSERT INTO manufacturer VALUES(3, 'Hewlett-Packard');
INSERT INTO manufacturer VALUES(4, 'Samsung');
INSERT INTO manufacturer VALUES(5, 'Seagate');
INSERT INTO manufacturer VALUES(6, 'Crucial');
INSERT INTO manufacturer VALUES(7, 'Gigabyte');
INSERT INTO manufacturer VALUES(8, 'Huawei');
INSERT INTO manufacturer VALUES(9, 'Xiaomi');

INSERT INTO product VALUES(1, 'Disco duro SATA3 1TB', 86.99, 5);
INSERT INTO product VALUES(2, 'Memoria RAM DDR4 8GB', 120, 6);
INSERT INTO product VALUES(3, 'Disco SSD 1 TB', 150.99, 4);
INSERT INTO product VALUES(4, 'GeForce GTX 1050Ti', 185, 7);
INSERT INTO product VALUES(5, 'GeForce GTX 1080 Xtreme', 755, 6);
INSERT INTO product VALUES(6, 'Monitor 24 LED Full HD', 202, 1);
INSERT INTO product VALUES(7, 'Monitor 27 LED Full HD', 245.99, 1);
INSERT INTO product VALUES(8, 'Portátil Yoga 520', 559, 2);
INSERT INTO product VALUES(9, 'Portátil Ideapd 320', 444, 2);
INSERT INTO product VALUES(10, 'Impresora HP Deskjet 3720', 59.99, 3);
INSERT INTO product VALUES(11, 'Impresora HP Laserjet Pro M26nw', 180, 3);
select *
from product;


id
name
price
manufacturer_id


1
Disco duro SATA3 1TB
86.99
5

2
Memoria RAM DDR4 8GB
120
6

3
Disco SSD 1 TB
150.99
4

4
GeForce GTX 1050Ti
185
7

5
GeForce GTX 1080 Xtreme
755
6

6
Monitor 24 LED Full HD
202
1

7
Monitor 27 LED Full HD
245.99
1

8
Portátil Yoga 520
559
2

9
Portátil Ideapd 320
444
2

10
Impresora HP Deskjet 3720
59.99
3

11
Impresora HP Laserjet Pro M26nw
180
3


select *
from manufacturer;


id
name


1
Asus

2
Lenovo

3
Hewlett-Packard

4
Samsung

5
Seagate

6
Crucial

7
Gigabyte

8
Huawei

9
Xiaomi


select manufacturer_id
from product
group by manufacturer_id
having count(1) >= 2


manufacturer_id


1

2

3

6


select m.name
from manufacturer m
inner join (
  select manufacturer_id
  from product
  group by manufacturer_id
  having count(1) >= 2
) as s on s.manufacturer_id = m.id


name


Asus

Lenovo

Hewlett-Packard

Crucial


SELECT manufacturer.name FROM product 
INNER JOIN manufacturer ON product.manufacturer_id = manufacturer.id 
WHERE (SELECT COUNT(producto.id) FROM producto) >= 2 GROUP BY manufacturer.name;

Table 'shop.producto' doesn't exist

id	name	price	manufacturer_id
1	Disco duro SATA3 1TB	86.99	5
2	Memoria RAM DDR4 8GB	120	6
3	Disco SSD 1 TB	150.99	4
4	GeForce GTX 1050Ti	185	7
5	GeForce GTX 1080 Xtreme	755	6
6	Monitor 24 LED Full HD	202	1
7	Monitor 27 LED Full HD	245.99	1
8	Portátil Yoga 520	559	2
9	Portátil Ideapd 320	444	2
10	Impresora HP Deskjet 3720	59.99	3
11	Impresora HP Laserjet Pro M26nw	180	3

id	name
1	Asus
2	Lenovo
3	Hewlett-Packard
4	Samsung
5	Seagate
6	Crucial
7	Gigabyte
8	Huawei
9	Xiaomi