/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 vote202 views1 answer
Delete from inner join sql
SQL
2 votes207 views1 answer
Sql server check for value in multiple columns
SQL
0 vote238 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote196 views1 answer
Alasql delete column
SQL
0 vote206 views1 answer
Database get 10 user aleatory
SQL
15 votes179 views4 answers
T-sql drop function if exists
SQL
0 vote195 views1 answer
How to check which sp is running in sql server
SQL
0 vote197 views1 answer
Oracle gather table statistics
SQL
0 vote191 views1 answer
Mysql select where field like in list
SQL
0 vote238 views1 answer
Reindexing all tables sql server
SQL