How to Count in Differnet type of tables in database,?

Question

6 different type of tables in database . 

How to write a query and How to Diplay in .Cs?

Table Is : 

Table 1: Price 1$,

Table 2: Price 1$,

Table 3: Price 1$,

Table 4: Price 1$,

Table 5: Price 1$,

Table 6: Price 1$,  

How to Write A Query , In SqlServer ,  Or Label code also

How to Write Code Or Query ...