database - SQL: Find filled area -

-

this question has answer here:

i have table:

create table coordinates (   x integer not null,   y integer not null,   color varchar(1) not null,   primary key(x,y) )

here sample data:

insert coordinates   (x, y, color) values   (0, 4, 'g'),   (1, 0, 'g'),   (1, 1, 'g'),   (1, 2, 'g'),   (1, 3, 'g'),   (0, 4, 'g'),   (1, 0, 'g'),   (1, 1, 'g'),   (1, 2, 'g'),   (1, 3, 'g'),   (1, 4, 'g'),   (2, 0, 'b'),   (2, 1, 'g'),   (2, 2, 'g'),   (2, 3, 'g'),   (2, 4, 'g'),   (4, 0, 'b'),   (4, 1, 'r'),   (4, 2, 'r'),   (4, 3, 'g'),   (4, 4, 'g'),   (6, 0, 'r'),   (6, 1, 'g'),   (6, 2, 'g'),   (6, 3, 'r'),   (6, 4, 'r') ;

i trying write query finds largest-area rectangles. assuming rectangle defined bottom left , top right, , 1/4 r, 1/4 b, 1/4 g, 1/4 y.

so result should this:

x1 | y1 | x2 | y2 | area -------------------------  0    1    6    9     58  1    2    4    7     58

make function calculates area , query function biggest one.


Comments

Post a Comment

Popular posts from this blog

Python __call__ special method practical example -

-
i know __call__ method in class triggered when instance of class called. however, have no idea when can use special method, because 1 can create new method , perform same operation done in __call__ method , instead of calling instance, can call method. i appreciate if gives me practical usage of special method. django forms module uses __call__ method nicely implement consistent api form validation. can write own validator form in django function. def custom_validator(value): #your validation logic django has default built-in validators such email validators, url validators etc., broadly fall under umbrella of regex validators. implement these cleanly, django resorts callable classes (instead of functions). implements default regex validation logic in regexvalidator , extends these classes other validations. class regexvalidator(object): def __call__(self, value): # validation logic class urlvalidator(regexvalidator): def __call__(self, valu...
Read more

How can I edit my VIM config so that Vim treats ".ejs" files the same as it currently treats my html files? -

-
what put in vim config? how change it? i want .html extension...because html... i think need au bufread,bufnewfile *.ejs setfiletype html au short autocmd docs it's idea put inside test if has("autocmd") au bufread,bufnewfile *.ejs setfiletype html endif to avoid error messages if ever use cut-down version of vim doesn't support feature. finally, if have default filetype rule like: au bufread,bufnewfile * setfiletype text then *.ejs rule must above it.
Read more