/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

3 votes343 views1 answer
Pl sql escape &
SQL
0 vote373 views1 answer
Default column value in sql same as another column laravel
SQL
1 vote300 views1 answer
Insert into sql
SQL
-1 vote381 views1 answer
Ms sql select datetime as date
SQL
0 vote331 views1 answer
Call function in query sql server
SQL
34 votes383 views5 answers
Oracle alter table add column
SQL
22 votes379 views3 answers
How to join three tables in sql using joins
SQL
0 vote343 views1 answer
Sql server manager close connection
SQL
0 vote335 views2 answers
Sql if empty then
SQL
0 vote356 views1 answer
Excel vba import data to sql server
SQL