MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Table1 (id INTEGER PRIMARY KEY, data VARCHAR(5));
INSERT INTO Table1 (id, data) VALUES
  ('0', 'zero'),
  ('1', 'one'),
  ('2', 'two'),
  ('3', 'three');

Records: 4  Duplicates: 0  Warnings: 0


CREATE TABLE Table2 (id INTEGER PRIMARY KEY, related_tableone_id INTEGER, positive BOOLEAN);
INSERT INTO Table2 (id, related_tableone_id, positive) VALUES
  ('0', '1', '0'),
  ('1', '2', '1'), ('2', '2', '0'), ('3', '2', '1'),
  ('4', '3', '1'), ('5', '3', '1');

Records: 6  Duplicates: 0  Warnings: 0


SELECT t1.id, t1.data       
FROM Table1 t1 LEFT JOIN Table2 t2
ON t2.related_tableone_id = t1.id
GROUP BY t1.id
ORDER BY SUM(CASE t2.positive WHEN true THEN 1 WHEN false THEN -1 ELSE 0 END) DESC;


id
data


3
three

2
two

0
zero

1
one


SELECT t1.*
FROM Table1 t1
ORDER BY (
  SELECT COALESCE(SUM(CASE t2.positive WHEN true THEN 1 WHEN false THEN -1 END) , 0)
  FROM Table2 t2 
  WHERE t2.related_tableone_id = t1.id
) DESC;


id
data


3
three

2
two

0
zero

1
one