<div>
<div class="content wysiwyg-content">
I am building a simple scoring application and want to output a scoreboard using mysql.<br />
This is an example of how I would like to output (from google images)<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/11_w46/1009681/scoreboardexample.jpg" target="_blank" title="scoreboard example (108 KB)"><img alt="scoreboard example" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/11_w46/800_1009681/scoreboardexample.jpg" /></a><br />
These are my tables<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/11_w46/1009701/team.png" target="_blank" title="team (188 KB)"><img alt="team" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/11_w46/800_1009701/team.png" /></a><a href="https://filedb.experts-exchange.com/incoming/2015/11_w46/1009702/round.png" target="_blank" title="round (181 KB)"><img alt="round" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/11_w46/800_1009702/round.png" /></a><a href="https://filedb.experts-exchange.com/incoming/2015/11_w46/1009703/score.png" target="_blank" title="score (222 KB)"><img alt="score" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/11_w46/800_1009703/score.png" /></a><a href="https://filedb.experts-exchange.com/incoming/2015/11_w46/1009704/relationship.png" target="_blank" title="relationship (113 KB)"><img alt="relationship" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/11_w46/800_1009704/relationship.png" /></a><br />
But i'm stuck on how to achieve this query...<br />
I need each ROUND to have its own column with to total of each team at the end.<br />
<br />
Can anyone help me this this??
</div>
</div>


team.png

scoreboardexample.jpg

relationship.png

score.png

round.png

I am building a simple scoring application and want to output a scoreboard using mysql.
This is an example of how I would like to output (from google images)


These are my tables





But i'm stuck on how to achieve this query...
I need each ROUND to have its own column with to total of each team at the end.

Can anyone help me this this??

MySQL Scoreboard with Ranking

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.