I have a database that has these two tables:
and what I want to do is show the percentage of coemrcial and residential that are loaded in a Chart.js with php, how could I do it?