【正确答案】(1)SELECT FACT
FROM GOODS
WHERE FACT NOT IN
(SELECT FACT
FROM GOODS
WHERE GNAME='微波炉')
(2)SELECT S#, SNAME
FROM SHOPS
WHERE ADDR LIKE'南京路'
(3)SELECT SNAME, MANAG
FROM SHOPS
WHERE S#NOT IN
(SELECT S#
FROM SALES
WHERE G#IN
(SELECT G#
FROM COODS
WHERE FACT='南华')
(4)SELECT GNAME, TYPE, FACT
FROM GOODS
WHERE G#IN
(SELECT G#
FROM SALES
WHERE S#='S01'
AND G#IN
(SELECT G$
FROM SALES
WHERE S#='S02'))
(5)SELECT COUNT(DISTINCT FACT)
FROM GOODS
WHERE GNAME='电视机'
(6)SEIECT C#
FROM SALES
GROUP BY G#
HAVING AVG(QTY)＞=ALL(SELECT AVG(QTY)
FROM SALES
GROUP BY(#)