Expressions as Values in Columns Sells(bar,beer,price) ◆Any expression that makes sense can SELECT bar,beer, appear as an element of a SELECT clause. price*120 AS priceInYen FROM Sells; bar beer pricelnYen Joe's Bud 300 Sue's Miller 360 Note:no WHERE clause is OK.Expressions as Values in Columns S ells ( b a r, beer, pric e) S E L E C T bar, be e r, price*1 2 0 A S p ri ceI n Y e n FROM S ells ; bar beer priceInYen Joe ’ s Bud 300 Sue ’ s Miller 360 … … … z Note: no W H E R E clause is OK. ‹Any expression that makes sense can appear as an element of a SELECT clause