下面的代码将为您提供所需的信息，但它是一个查询，而不是一个表。如果确实要创建一个列/字段名为人名、行/记录仅为计数的表，则应查看create table文档：https://dev.mysql.com/doc/refman/5.5/en/creating-tables.html 以及插入命令文档：https://dev.mysql.com/doc/refman/8.0/en/insert.html.

SELECT
    COUNT(names) AS COUNT,
    names
FROM
    table_team
WHERE
    names in ('jhon', 'jack')
GROUP BY
    names

在原始海报的新信息后添加：

SELECT
    *
FROM
    (SELECT COUNT(*) AS nameJack FROM table_team WHERE `names` = 'jack') AS SUB1
INNER JOIN
    (SELECT COUNT(*) AS nameJhon FROM table_team WHERE `names` = 'jhon') AS SUB2
    ON
    (
    SUB1.`nameJack` <> SUB2.`nameJhon`
    OR
    SUB1.`nameJack` = SUB2.`nameJhon`
     )

对于mysql：
使用两个子选项。

SELECT (SELECT count(names)
               FROM table_team
               WHERE names = 'jhon') namejhon,
       (SELECT count(names)
               FROM table_team
               WHERE names = 'jack') namejack;

如果你想实现这一点，使用 CREATE TABLE ... AS SELECT ... 斯奈塔克斯。

CREATE TABLE jhon_and_jack
AS
SELECT (SELECT count(names)
               FROM table_team
               WHERE names = 'jhon') namejhon,
       (SELECT count(names)
               FROM table_team
               WHERE names = 'jack') namejack;

但是我不知道db2。但这也会给你一些提示。