Today all i’m going to do is actually quite a load. I’ve to do a quick project port from one engine to another, also making it a rocking layout, then write a presentation on Japan—i decided to do it about the different languages present on the japanese islands (japanese dialects, ryukyuan languages, ainu) with some culture overview included. I guess it’ll take a couple of hours, but i think i will enjoy doing it just as much as the chaos-theory one last week. This week i’ll also have to run a query like this:
SELECT `name`, COUNT(`important_people`.`name`) AS `people`, `presents`.*, `afford`
FROM `important_people`
LEFT JOIN `presents` ON `important_people`.`name` = `presents`.`person
LEFT JOIN `bank_account` ON `presents`.`price` < `bank_account`.`afford`
WHERE `presents`.`price` < `afford`/`people`
GROUP BY `name`
ORDER BY `name`
