/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

0 vote150 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote174 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote148 views1 answer
Pl sql disable trigger
SQL
0 vote150 views1 answer
Sql how to get courses that i have made prerequisites
SQL
1 vote143 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
11 votes160 views1 answer
Ddl view
SQL
0 vote151 views2 answers
Identity column in sql server
SQL
0 vote148 views1 answer
Mysql cli output to a file
SQL
1 vote173 views1 answer
Mysql search like order by best match
SQL
0 vote184 views1 answer
Compare strings lexicographically in sql
SQL