【答案解析】(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 GOODS
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)SELECT G#
FROM SALES
GROUP BY G#
HAVING AVG(QTY)>=ALL,(SELECT AVG(QTY)
FROM SALES
GROUP BY G#)