参考:
SELECT ((ytd_sales * price) * royalty)/100 AS 'Royalty Amount'
FROM titles
WHERE type = 'business'
ORDER BY title_id
SELECT ((ytd_sales * price) * royalty)/100 AS 'Royalty Amount'
FROM titles
WHERE type = 'business'
ORDER BY title_id
调试时的语句如下
update score set point=((examscore-'68.4')/'13.3506554146229')*'4'*'1' from score,course where score.courseno=course.courseno and years='2004' and term='1' and course.coursename='微机接口'