/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 vote361 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote396 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote346 views1 answer
Sql anywhere create procedure
SQL
0 vote405 views2 answers
Mysql cast to varchar
SQL
6 votes324 views2 answers
Spring data jpa application.properties mysql
SQL
5 votes385 views1 answer
Mysql add user with all privileges
SQL
0 vote334 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
7 votes365 views2 answers
Postgres concat
SQL
3 votes379 views1 answer
Sql print all names that start with a given letter
SQL
0 vote336 views1 answer
Wordpress sql change site url
SQL