sample175.sql

来自「T-SQL示例大全」· SQL 代码 · 共 15 行

/* 文件名称: Sample175.sql */
USE pubs

SELECT T.title_id, S.stor_id, ST.stor_name, city, state,
       Revenue=T.price*S.qty
  FROM titles T 
       INNER JOIN sales S ON T.title_id=S.title_id
       INNER JOIN stores ST ON S.stor_id=ST.stor_id      
  WHERE T.price*S.qty < 
    (SELECT 0.80*AVG(price*qty)
       FROM titles T2
            INNER JOIN sales S2
            ON T2.title_id=S2.title_id
       WHERE T.title_id=T2.title_id )