哪位好心人幫個忙??？

學生吧，上課不好好學習。到網(wǎng)上來求人幫嗎啊。這么簡單的問題也不自己動腦子想想。不能告訴你，告訴你了就是害你啊。

沒給列名怎么給你寫....
這些是最簡單的SQL查詢語句了,你照著教科書寫就行
基本格式就是:
SELECT <列名>
FROM <表名>
WHERE [查詢條件]

..............................................................................................................................................................................................................................................................

(1)select * from members where adr='北京'
(2)select 名稱, 價格, 數(shù)量,價格*數(shù)量 as 總額 from products
(3)select avg(月薪) as 平均月薪 ,max(月薪) as 最高月薪,sum(月薪) as 月薪之和 from members
(4)select * from members where adr = '湖南株洲' and age >30