Get table sizes in sql

file.sql

select 	 table_name,
         round((data_length + index_length)/1024/1024/1024, 2) as `gb` 
from     information_schema.tables
where    table_schema = "schema"
order by `gb` desc;