IntroductiontoDatabase教学幻灯片讲义.pptVIP

3-* 3.8.1 Derived Relations派生关系 Find the average account balance of those branches where the average account balance is greater than $500 select branch-name, avg-balance from (select branch-name, avg (balance) from account group by branch-name) as result (branch-name, avg-balance) where avg-balance 500 Note: result: is a derived relations, a temporary (view) relation the attributes of result can be used directly in the where clause. Please include this query in EX 3. account 3-* 3.8.2 The with Clause with clause: (introduced in SQL:1999) create view clause crates a