/SQL/How to combine two sql queries in one result

How to combine two sql queries in one result

How to combine the results of two different queries into a single query

select
            t.name,
            sum(case when m.winner = t.id then 1 else 0 end) 'Matches_Won'
            count(*) 'Matches_Played'
    from
            test.team t 
        inner join
            test.match_scores m
               on m.home_team = t.id or m.away_team = t.id
    group by
            t.id
    order by
            Matches_Won,
            Matches_Played

Source: stackoverflow.com

How to combine the results of two different queries into a single query

SELECT t.name, 
       SUM(m.winner = t.id) 'Matches_Won',
       SUM(t.id IN (m.home_team, m.away_team)) 'Matches_Played'
FROM test.team t 
CROSS JOIN test.match_scores m
GROUP BY t.name;

Source: stackoverflow.com

Similar codes

-1 vote244 views4 answers
Sql view postgresql
SQL
16 votes228 views4 answers
Mysql import from sql file
SQL
-1 vote251 views5 answers
Left join
SQL
2 votes240 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote244 views1 answer
Sql order by where condition
SQL
7 votes254 views4 answers
Index in mysql
SQL
24 votes238 views4 answers
Mysql datetime
SQL
3 votes274 views1 answer
What is having
SQL
0 vote246 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
6 votes251 views4 answers
Mysql group by date
SQL