/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 vote121 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote125 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote128 views1 answer
Mysql disable triggers
SQL
13 votes97 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote101 views1 answer
Print orcale
SQL
0 vote110 views1 answer
Mysql two joins
SQL
4 votes109 views4 answers
Sqlite describe table
SQL
-2 votes116 views1 answer
Use of where in left join in mysql
SQL
1 vote127 views1 answer
Opensuse restart MySQL
SQL
0 vote116 views1 answer
How to select a row in sql
SQL