GHA.

[azurelunatic]

SQL. I can do *calculated* columns just fine, but I'm not sure how to handle this one that says to have it say "High-priced" in a column if the price is above 16000. GHA.

Help?

Comments

[azurelunatic]

Oh, THAT'S just fine... what I was talking about had no such pricey_descriptor column; we were expected to make the system pretend one was there.

I guess my brain was on vacation that day?

Ah well.

For the few problems I failed to make it get, I set the offending code and results in two points larger font, and bolded it, for the instructor's convenience.

[godai.livejournal.com]

create view accounts (title_id, advance, pricey descriptor)
as select titles.title_id, advance,
if price > 1600 then "High-priced" else ""
from titles, price



something like that.

[azurelunatic]

*facepalm* Thank you.