как получить кол-во ставок из таблицы bets на определенногоый товар из таблицы staff sql

Нужно показать количество ставок из таблицы bets на определенном товаре из таблицы staff(они связаны по id)

CREATE DATABASE  IF NOT EXISTS yeticave
    DEFAULT CHARACTER SET utf8
    DEFAULT COLLATE UTF8_GENERAL_CI;
USE yeticave;
CREATE TABLE  IF NOT EXISTS categories (
id       INT AUTO_INCREMENT PRIMARY KEY,
category    CHAR(128)
);
CREATE TABLE  IF NOT EXISTS staff (
id       INT AUTO_INCREMENT PRIMARY KEY,
staff_name  CHAR(128),
id_category TINYINT,
cost INT,
url_image TEXT
);
CREATE TABLE IF NOT EXISTS users (
id  INT AUTO_INCREMENT PRIMARY KEY,
email CHAR(128),
user_name CHAR(128),
password CHAR(128)
);
CREATE TABLE IF NOT EXISTS bets (
id  INT AUTO_INCREMENT PRIMARY KEY,
id_product INT,
id_user INT,
price INT,
bet_time DATETIME
);
CREATE UNIQUE INDEX category_index ON categories(category);

INSERT INTO categories (category) VALUES ('Доски и лыжи'), ('Крепления'), ('Ботинки'), ('Одежда'), ('Инструменты'), ('Разное');
INSERT INTO staff (staff_name, id_category, cost, url_image) VALUES ('2014 Rossignol District Snowboard', 1, 109999, 'img/lot-1.jpg'), ('DC Ply Mens 2016/2017 Snowboar', 1, 159999, 'img/lot-2.jpg'), ('Kpeпления Union Contact Pro 2015 года paзмep L/XL', 2, 8000, 'img/lot-3.jpg'), ('Ботинки для сноуборда DC Mutiny Charocal', 3, 10999, 'img/lot-4.jpg'), ('Куртка для сноуборда DC Mutiny Charocal', 4, 7500, 'img/lot-5.jpg'), ('Маска Oakley Canopy', 1, 5400, 'img/lot-6.jpg');
INSERT INTO users (email, user_name, password) VALUES ('[email protected]', 'Игнат','$2y$10$OqvsKHQwr0Wk6FMZDoHo1uHoXd4UdxJG/5UDtUiie00XaxMHrW8ka'), ('[email protected]', 'Леночка','$2y$10$bWtSjUhwgggtxrnJ7rxmIe63ABubHQs0AS0hgnOo41IEdMHkYoSVa'), ('[email protected]', 'Руслан','$2y$10$2OxpEH7narYpkOT1H5cApezuzh10tZEEQ2axgFOaKW.55LxIJBgWW');
INSERT INTO bets (id_product, id_user, price, bet_time) VALUES
 (1, 1, 10000, '2011-04-15 00:03:00'),
 (1, 3, 999999, '2012-04-18 00:03:00'),
 (2, 2, 500, '2015-04-15 00:03:00'),
 (2, 1, 432, '2021-04-15 00:03:00'),
 (3, 2, 764, '2022-04-15 00:03:00'),
 (3, 1, 54776, '2017-04-15 00:03:00'),
 (4, 1, 2453345, '2016-04-15 00:03:00'),
 (4, 3, 746657, '2011-04-15 00:03:00'),
 (5, 1, 3452435, '2011-04-15 00:03:00'),
 (5, 3, 4545, '2011-04-15 00:03:00'),
 (6, 1, 8778, '2011-04-15 00:03:00'),
 (6, 2, 2131, '2011-04-15 00:03:00');
SELECT category FROM categories;
SELECT staff_name FROM staff
WHERE id = 1
JOIN categories ON staff.category_id = categories.id;
UPDATE staff SET staff_name = 'хз'
WHERE id = 4;

SELECT staff_name, cost, url_image FROM staff JOIN categories ON staff.category_id = categories.id JOIN bets COUNT(bets.product_id) ON bets.id_product = staff.id;