用于计算列中存在的-1和1的数量的sql查询

SELECT
  COUNT(CASE WHEN column_name = -1 THEN 1 END) AS count_minus_one,
  COUNT(CASE WHEN column_name = 1 THEN 1 END) AS count_one
FROM table_name;

SELECT
  COUNT(CASE WHEN column_name = -1 THEN 1 END) AS count_minus_one,
  COUNT(CASE WHEN column_name = 1 THEN 1 END) AS count_one,
  COUNT(*) AS total_count
FROM table_name;

SELECT
  COUNT(CASE WHEN wrong_column_name = -1 THEN 1 END) AS count_minus_one,
  COUNT(CASE WHEN wrong_column_name = 1 THEN 1 END) AS count_one
FROM wrong_table_name;

SELECT
  COUNT(CASE WHEN column_name = '-1' THEN 1 END) AS count_minus_one,
  COUNT(CASE WHEN column_name = '1' THEN 1 END) AS count_one
FROM table_name;