/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 vote204 views1 answer
Mysql return text after a final full stop
SQL
2 votes222 views1 answer
Merge two columns in sql oracle
SQL
6 votes183 views3 answers
Create database mysql utf8
SQL
1 vote187 views1 answer
Sql select table header
SQL
0 vote168 views1 answer
Check duplicate values plsql
SQL
0 vote199 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote177 views1 answer
Changing name of column and datatype in sql
SQL
0 vote255 views1 answer
Install ms sql server management studio
SQL
0 vote180 views1 answer
Casterar postgres
SQL
6 votes184 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL