/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 vote162 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote166 views1 answer
Sql date time query find
SQL
11 votes152 views1 answer
Creating tables in sql with python
SQL
0 vote143 views2 answers
Mysql to python pandas
SQL
0 vote140 views1 answer
Sql date d'aujourd'hui
SQL
0 vote108 views1 answer
Connection error in mysql workbench
SQL
-1 vote141 views3 answers
Error mysql shutdown unexpectedly
SQL
24 votes138 views4 answers
How to add column sql
SQL
0 vote131 views1 answer
Export partttion and import in oracle
SQL
4 votes188 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL