You need to write your own custom SQL query and PHP code to handle it.
Again, we aren’t going to write code for you. We are here to help, not do your wwrk for you.
I am not that Great with php, I am just asking, sure many ppl get data from DB to thier pages!
They do, and they do it by putting together custom PHP code.
As a start (again, not doing it for you), YOU need to do the work yourself), look at:
Everything that you need to make your own PHP script and set up your own plugin and shortcode is in there. That’s all that we can do for you. Now it’s up to you to go and learn how to make it all work.