sample175.sql

100多个SQL小程序,包含游标,基本增删改查,希望多你有用

/* 文件名称: 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 )