Как в SQL работать со списками строк?

CREATE TABLE t (name CHAR(50), num INT NOT NULL);
INSERT INTO t VALUES ('text 1',1);
INSERT INTO t VALUES ('text 1',2);
INSERT INTO t VALUES ('text 2',3);
INSERT INTO t VALUES ('text 10',4);
INSERT INTO t VALUES (NULL,5);

SELECT t.name, SUM(t.num)
FROM t 
GROUP BY t.name
;

CREATE TABLE #list (name CHAR(50) UNIQUE NOT NULL);
INSERT INTO #list VALUES ('text 1');
INSERT INTO #list VALUES ('text 2');
INSERT INTO #list VALUES ('text 3');
 
SELECT #list.name, SUM(t.num)
FROM #list
LEFT JOIN t ON (#list.name = t.name)
GROUP BY #list.name
;
 
DROP TABLE #list;

SELECT t.name, SUM(t.num)
  FROM t 
  WHERE t.name IN ('text 1','text 2','text 3')
  GROUP BY t.name

SELECT U.name, SUM(t.num) AS SumNum
  FROM (SELECT 'text 1' AS name
        UNION
        SELECT 'text 2' AS name
        UNION
        SELECT 'text 3' AS name) U
    LEFT JOIN t ON U.name = t.name
  GROUP BY U.name

CREATE TABLE #list (name CHAR(50) UNIQUE NOT NULL);
INSERT INTO #list VALUES ('text 1');
INSERT INTO #list VALUES ('text 2');
INSERT INTO #list VALUES ('text 3');

SELECT 'text 1' AS name INTO #list 
UNION SELECT 'text 2' 
UNION SELECT 'text 3'
;