关于#mysql#查询结果，选择其中两项进行处理的问题，如何解决？

Question

SELECT 
g.`name` '业务组',
case q.`type`
WHEN "QUOTA_TYPE_MACHINE_SERVER_NUMBER" then ('虚机数量')
WHEN "QUOTA_TYPE_MACHINE_CPU" then 'CPU'
WHEN "QUOTA_TYPE_MACHINE_MEMORY" then ('内存')
else ('存储')
END '类型',
q.`total` '配额',
q.`used` '已使用',
q.`total`-q.`used` '剩余',
CONCAT(round(q.`used`/q.`total`*100,2), '%') '使用率'
FROM `business_group` g, `business_group_quota` q
WHERE g.`id` = q.`business_group_id`

现在需要将内存和存储的单位转换为G

更新，用case这个方法，但是他不进行计算啊

SELECT 
g.`name` '业务组',
CASE q.`type`
WHEN "QUOTA_TYPE_MACHINE_SERVER_NUMBER" then ('虚机数量')
WHEN "QUOTA_TYPE_MACHINE_CPU" then 'CPU'
WHEN "QUOTA_TYPE_MACHINE_MEMORY" then ('内存')
ELSE ('存储')
END '类型',
CASE q.`total`
WHEN q.`type` = 'QUOTA_TYPE_MACHINE_MEMORY' THEN ROUND(q.`total`/1024/1024/1024)
WHEN q.`type` = 'QUOTA_TYPE_MACHINE_STORAGE' THEN ROUND(q.`total`/1024/1024/1024)
ELSE q.`total`
END'配额',
q.`used` '已使用', 
q.`total`-q.`used` '剩余',
CONCAT(ROUND(q.`used`/q.`total`*100,2), '%') '使用率'
FROM `business_group` g, `business_group_quota` q
WHERE g.`id` = q.`business_group_id`

Answer 1

那你再写case when then，如果是内存或硬盘，就q.total/1024/1024/1024