Outputting data from a $select query as table

[Mousie]

Hey all!

I'm looking to create a custom php block that pulls data from an internal database and outputs it in a table format. I've read the guide here, and with some adjustments have managed to get it to pull data from the correct database, and to select the columns that I want. 

What I can't figure out is how get it to output a table of three columns or more. 

Is there a code snippet I can look at that does this? Much love if you can guide me through how to include/exclude columns.

Bonus question: If I were to select a column that contained only number fields, is there a way to get it to sum those fields into a single value and output the result?