/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 vote359 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote319 views1 answer
How to print records of employees hired in particular month in oracle
SQL
1 vote318 views1 answer
Oracle rolling back
SQL
3 votes350 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
1 vote355 views1 answer
Sqlalchemy on delete set null
SQL
0 vote337 views2 answers
Add new column after in sql
SQL
1 vote322 views1 answer
How to use a trigger to validate input data
SQL
-1 vote293 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote311 views1 answer
Mysql local password denied
SQL
4 votes327 views2 answers
How to insert ip address in mysql using php
SQL