Input
- Input table: rft_model, output by any of the DecisionForest Examples
SQL Call
SELECT task_index, tree_num, variable_col, level_col, cnt FROM DecisionForestEvaluator ( ON rft_model ) AS dt ORDER BY 1,2;
Output
Two worker nodes construct 25 trees each. The function outputs the level and count of variables for each tree and worker at each node.
task_index tree_num variable_col level_col cnt ---------- -------- ------------ --------- ---- 1 0 gashw 4 1 1 0 recroom 1 1 1 0 stories 2 1 1 0 prefarea 4 1 1 0 bedrooms 3 1 1 0 gashw NULL NULL 1 0 lotsize NULL NULL 1 0 bathrms NULL NULL 1 0 price NULL NULL 1 0 price 3 1 1 0 stories NULL NULL 1 0 price 4 1 1 0 lotsize 2 1 1 0 price 0 1 1 0 bathrms 4 1 1 0 garagepl NULL NULL 1 0 recroom NULL NULL 1 0 prefarea NULL NULL 1 0 garagepl 3 2 1 0 bedrooms NULL NULL 1 1 garagepl 1 1 1 1 price NULL NULL 1 1 stories 0 1 1 1 lotsize 1 1 1 1 driveway 3 1 1 1 lotsize 4 1 1 1 prefarea NULL NULL 1 1 driveway NULL NULL 1 1 price 2 1 1 1 garagepl NULL NULL 1 1 airco 4 1 1 1 price 4 1 1 1 stories NULL NULL 1 1 gashw 2 1 1 1 lotsize 2 1 1 1 lotsize 3 1 1 1 airco NULL NULL 1 1 prefarea 4 1 1 1 gashw NULL NULL 1 1 lotsize NULL NULL 1 2 price 0 1 1 2 price 2 1 1 2 price 3 1 1 2 price NULL NULL 1 2 airco NULL NULL 1 2 garagepl NULL NULL 1 2 airco 1 1 1 2 garagepl 2 1 1 3 stories 2 1 1 3 lotsize NULL NULL 1 3 prefarea 0 1 1 3 price 4 1 1 3 recroom NULL NULL 1 3 bedrooms 3 1 1 3 price 3 2 1 3 airco NULL NULL 1 3 price 2 1 1 3 price 1 1 1 3 price NULL NULL 1 3 prefarea NULL NULL 1 3 recroom 3 1 1 3 lotsize 4 1 1 3 bathrms NULL NULL 1 3 stories NULL NULL 1 3 bathrms 2 1 1 3 airco 1 1 1 3 bedrooms NULL NULL 1 4 fullbase 2 1 1 4 stories NULL NULL 1 4 gashw NULL NULL 1 4 price 3 1 1 4 lotsize NULL NULL 1 4 fullbase NULL NULL 1 4 gashw 1 1 1 4 price 1 1 1 4 bathrms NULL NULL 1 4 stories 4 1 1 4 lotsize 0 1 1 4 price 2 1 1 4 bathrms 3 1 1 4 price NULL NULL 1 5 airco NULL NULL 1 5 airco 4 1 1 5 fullbase NULL NULL 1 5 lotsize NULL NULL 1 5 stories 4 1 1 5 driveway 3 1 1 5 price 4 1 1 5 fullbase 1 1 1 5 price NULL NULL 1 5 stories NULL NULL 1 5 prefarea 4 1 1 5 prefarea NULL NULL 1 5 stories 1 1 1 5 garagepl 2 1 1 5 garagepl 3 1 1 5 lotsize 0 1 1 5 garagepl NULL NULL 1 5 driveway NULL NULL 1 5 price 2 3 1 6 prefarea NULL NULL 1 6 price NULL NULL 1 6 price 4 2 1 6 lotsize 3 1 1 6 garagepl 2 1 1 6 garagepl 0 1 1 6 airco NULL NULL 1 6 bathrms NULL NULL 1 6 stories 2 1 1 6 airco 4 1 1 6 lotsize 4 1 1 6 bedrooms NULL NULL 1 6 prefarea 4 1 1 6 price 1 1 1 6 prefarea 2 1 1 6 bedrooms 3 1 1 6 gashw NULL NULL 1 6 gashw 3 1 1 6 garagepl NULL NULL 1 6 fullbase 3 2 1 6 recroom 4 1 1 6 fullbase NULL NULL 1 6 bathrms 4 2 1 6 bathrms 1 1 1 6 stories NULL NULL 1 6 lotsize NULL NULL 1 6 recroom NULL NULL 1 7 price 4 1 1 7 stories 3 1 1 7 airco 2 1 1 7 fullbase 4 1 1 7 bathrms 0 1 1 7 price 2 2 1 7 bathrms NULL NULL 1 7 stories NULL NULL 1 7 fullbase NULL NULL 1 7 price NULL NULL 1 7 bathrms 1 1 1 7 price 3 2 1 7 price 1 1 1 7 airco NULL NULL 1 8 bedrooms 3 1 1 8 airco 0 1 1 8 lotsize 2 1 1 8 bathrms 4 1 1 8 stories 1 1 1 8 garagepl 4 1 1 8 recroom 2 1 1 8 airco NULL NULL 1 8 garagepl 2 1 1 8 driveway 1 1 1 8 bathrms NULL NULL 1 8 garagepl NULL NULL 1 8 price NULL NULL 1 8 price 2 1 1 8 gashw NULL NULL 1 8 recroom NULL NULL 1 8 stories NULL NULL 1 8 driveway NULL NULL 1 8 lotsize NULL NULL 1 8 price 3 1 1 8 price 4 3 1 8 bedrooms NULL NULL 1 8 recroom 4 1 1 8 gashw 3 1 1 8 lotsize 3 2 1 9 gashw NULL NULL 1 9 airco NULL NULL 1 9 recroom 3 1 1 9 garagepl 4 1 1 9 garagepl NULL NULL 1 9 lotsize 3 2 1 9 lotsize 4 2 1 9 price 4 1 1 9 bedrooms 2 1 1 9 stories 1 1 1 9 recroom NULL NULL 1 9 price NULL NULL 1 9 fullbase NULL NULL 1 9 stories NULL NULL 1 9 bedrooms NULL NULL 1 9 fullbase 4 1 1 9 price 3 1 1 9 airco 2 1 1 9 lotsize 2 1 1 9 gashw 1 1 1 9 lotsize 0 1 1 9 lotsize NULL NULL 1 10 price 2 1 1 10 price 1 1 1 10 garagepl 0 1 1 10 lotsize 3 1 1 10 driveway 2 1 1 10 prefarea 2 1 1 10 bedrooms 3 2 1 10 driveway NULL NULL 1 10 bedrooms NULL NULL 1 10 bathrms NULL NULL 1 10 garagepl NULL NULL 1 10 stories NULL NULL 1 10 price NULL NULL 1 10 bathrms 1 1 1 10 lotsize NULL NULL 1 10 prefarea NULL NULL 1 10 price 4 2 1 10 stories 4 2 1 10 lotsize 4 1 1 11 price 3 1 1 11 garagepl 2 1 1 11 airco 2 1 1 11 prefarea NULL NULL 1 11 airco NULL NULL 1 11 garagepl NULL NULL 1 11 price NULL NULL 1 11 stories NULL NULL 1 11 lotsize 1 1 1 11 price 0 1 1 11 stories 3 1 1 11 lotsize 4 2 1 11 prefarea 3 1 1 11 lotsize NULL NULL 1 12 prefarea 3 1 1 12 fullbase 2 1 1 12 price 4 1 1 12 stories 4 1 1 12 stories NULL NULL 1 12 garagepl NULL NULL 1 12 price 0 1 1 12 price NULL NULL 1 12 lotsize 1 1 1 12 airco NULL NULL 1 12 garagepl 4 1 1 12 prefarea NULL NULL 1 12 fullbase NULL NULL 1 12 lotsize NULL NULL 1 12 airco 3 1 1 12 price 3 1 1 12 lotsize 2 1 1 13 price NULL NULL 1 13 price 4 3 1 13 fullbase NULL NULL 1 13 bedrooms NULL NULL 1 13 prefarea 4 1 1 13 garagepl NULL NULL 1 13 stories NULL NULL 1 13 prefarea NULL NULL 1 13 lotsize NULL NULL 1 13 lotsize 4 3 1 13 price 3 1 1 13 lotsize 3 2 1 13 garagepl 2 1 1 13 stories 2 1 1 13 lotsize 1 2 1 13 stories 3 1 1 13 fullbase 2 1 1 13 bedrooms 0 1 1 13 garagepl 3 1 1 14 lotsize 1 1 1 14 garagepl 2 1 1 14 bathrms 3 1 1 14 bedrooms 4 3 1 14 bedrooms NULL NULL 1 14 lotsize 4 2 1 14 airco 0 1 1 14 garagepl NULL NULL 1 14 bathrms NULL NULL 1 14 price NULL NULL 1 14 lotsize 2 1 1 14 lotsize 3 1 1 14 airco NULL NULL 1 14 lotsize NULL NULL 1 14 prefarea 3 1 1 14 price 3 3 1 14 prefarea 2 1 1 14 bedrooms 1 1 1 14 prefarea NULL NULL 1 15 airco NULL NULL 1 15 bathrms NULL NULL 1 15 bathrms 0 1 1 15 lotsize 3 1 1 15 recroom 4 1 1 15 lotsize 2 1 1 15 garagepl NULL NULL 1 15 price NULL NULL 1 15 recroom NULL NULL 1 15 driveway NULL NULL 1 15 lotsize NULL NULL 1 15 lotsize 4 1 1 15 airco 3 1 1 15 garagepl 3 1 1 15 airco 2 1 1 15 price 1 1 1 15 driveway 1 1 1 16 garagepl NULL NULL 1 16 lotsize 1 1 1 16 price 3 1 1 16 price NULL NULL 1 16 price 2 1 1 16 price 0 1 1 16 lotsize NULL NULL 1 16 garagepl 2 1 1 17 price 4 2 1 17 driveway 2 1 1 17 lotsize NULL NULL 1 17 bedrooms NULL NULL 1 17 lotsize 3 1 1 17 airco 4 1 1 17 airco 1 1 1 17 fullbase 4 1 1 17 price 2 1 1 17 fullbase 3 1 1 17 airco NULL NULL 1 17 fullbase NULL NULL 1 17 garagepl 3 1 1 17 price NULL NULL 1 17 garagepl NULL NULL 1 17 bedrooms 2 2 1 17 garagepl 0 1 1 17 driveway NULL NULL 1 17 price 3 2 1 17 lotsize 1 1 1 18 driveway 2 1 1 18 lotsize 0 1 1 18 price 2 1 1 18 lotsize 3 3 1 18 lotsize 4 4 1 18 bedrooms 3 1 1 18 fullbase 3 1 1 18 fullbase 4 1 1 18 bathrms NULL NULL 1 18 stories NULL NULL 1 18 driveway NULL NULL 1 18 lotsize NULL NULL 1 18 bathrms 4 1 1 18 bedrooms 4 1 1 18 price 3 1 1 18 stories 2 1 1 18 bedrooms 2 1 1 18 airco 1 1 1 18 bathrms 1 1 1 18 prefarea 4 1 1 18 bedrooms NULL NULL 1 18 prefarea NULL NULL 1 18 fullbase NULL NULL 1 18 airco NULL NULL 1 18 price NULL NULL 1 19 airco 3 1 1 19 price 2 1 1 19 price NULL NULL 1 19 lotsize NULL NULL 1 19 bedrooms NULL NULL 1 19 airco NULL NULL 1 19 bathrms NULL NULL 1 19 bedrooms 4 1 1 19 price 3 1 1 19 lotsize 2 1 1 19 price 0 1 1 19 bathrms 1 1 1 20 garagepl 2 1 1 20 stories 2 1 1 20 garagepl 3 1 1 20 lotsize 4 2 1 20 prefarea 3 1 1 20 price 4 1 1 20 stories NULL NULL 1 20 prefarea NULL NULL 1 20 price NULL NULL 1 20 airco NULL NULL 1 20 fullbase NULL NULL 1 20 bathrms NULL NULL 1 20 garagepl NULL NULL 1 20 recroom NULL NULL 1 20 lotsize NULL NULL 1 20 recroom 4 1 1 20 airco 3 1 1 20 price 2 1 1 20 fullbase 1 1 1 20 bathrms 0 1 1 20 price 1 1 1 21 airco NULL NULL 1 21 prefarea NULL NULL 1 21 garagepl 1 1 1 21 bathrms NULL NULL 1 21 price 3 1 1 21 driveway NULL NULL 1 21 airco 4 2 1 21 bathrms 3 1 1 21 lotsize 2 1 1 21 price 0 1 1 21 stories 3 1 1 21 prefarea 2 1 1 21 lotsize NULL NULL 1 21 stories NULL NULL 1 21 garagepl NULL NULL 1 21 driveway 4 1 1 21 price NULL NULL 1 22 airco NULL NULL 1 22 fullbase NULL NULL 1 22 bathrms NULL NULL 1 22 garagepl NULL NULL 1 22 price NULL NULL 1 22 stories NULL NULL 1 22 driveway NULL NULL 1 22 lotsize NULL NULL 1 22 bedrooms NULL NULL 1 22 fullbase 4 1 1 22 price 4 1 1 22 driveway 4 1 1 22 bathrms 3 1 1 22 price 3 4 1 22 stories 3 1 1 22 airco 2 1 1 22 fullbase 2 1 1 22 garagepl 2 1 1 22 lotsize 2 1 1 22 lotsize 1 1 1 22 bedrooms 1 1 1 22 lotsize 0 1 1 23 fullbase NULL NULL 1 23 stories NULL NULL 1 23 bathrms 4 1 1 23 price 4 2 1 23 bathrms 3 2 1 23 bedrooms 2 1 1 23 stories 0 1 1 23 bedrooms NULL NULL 1 23 price 2 1 1 23 garagepl 1 1 1 23 fullbase 2 1 1 23 airco NULL NULL 1 23 airco 1 1 1 23 price NULL NULL 1 23 garagepl NULL NULL 1 23 price 3 2 1 23 bathrms NULL NULL 1 24 stories 2 1 1 24 recroom 3 1 1 24 bathrms 2 1 1 24 stories 4 1 1 24 airco NULL NULL 1 24 prefarea 4 1 1 24 airco 3 1 1 24 recroom NULL NULL 1 24 stories NULL NULL 1 24 prefarea NULL NULL 1 24 bathrms NULL NULL 1 24 price NULL NULL 1 24 price 4 2 1 24 prefarea 3 1 1 24 price 3 1 1 24 garagepl 1 1 1 24 price 0 1 1 24 garagepl NULL NULL 2 0 fullbase NULL NULL 2 0 garagepl NULL NULL 2 0 price NULL NULL 2 0 stories NULL NULL 2 0 driveway NULL NULL 2 0 lotsize NULL NULL 2 0 price 4 2 2 0 stories 4 1 2 0 fullbase 3 1 2 0 garagepl 3 1 2 0 lotsize 2 1 2 0 driveway 1 1 2 0 price 0 1 2 1 airco NULL NULL 2 1 prefarea NULL NULL 2 1 fullbase NULL NULL 2 1 garagepl NULL NULL 2 1 price NULL NULL 2 1 stories NULL NULL 2 1 recroom NULL NULL 2 1 garagepl 3 1 2 1 lotsize NULL NULL 2 1 bedrooms NULL NULL 2 1 prefarea 4 1 2 1 price 4 1 2 1 stories 4 1 2 1 bedrooms 4 1 2 1 airco 3 1 2 1 prefarea 3 1 2 1 price 3 1 2 1 price 2 2 2 1 stories 2 1 2 1 fullbase 1 1 2 1 bedrooms 1 1 2 1 recroom 0 1 2 1 lotsize 4 1 2 2 prefarea NULL NULL 2 2 fullbase NULL NULL 2 2 bathrms NULL NULL 2 2 garagepl NULL NULL 2 2 price NULL NULL 2 2 stories NULL NULL 2 2 recroom NULL NULL 2 2 driveway NULL NULL 2 2 lotsize NULL NULL 2 2 bedrooms NULL NULL 2 2 fullbase 4 1 2 2 garagepl 4 2 2 2 stories 4 2 2 2 lotsize 4 1 2 2 bedrooms 4 1 2 2 prefarea 3 1 2 2 price 3 1 2 2 recroom 3 1 2 2 lotsize 3 1 2 2 bathrms 2 1 2 2 price 2 1 2 2 bedrooms 2 2 2 2 bathrms 1 1 2 2 driveway 1 1 2 2 lotsize 0 1 2 3 price NULL NULL 2 3 driveway NULL NULL 2 3 bedrooms NULL NULL 2 3 price 4 1 2 3 bedrooms 3 1 2 3 price 2 2 2 3 price 1 1 2 3 bedrooms 1 1 2 3 driveway 0 1 2 4 price NULL NULL 2 4 price 1 1 2 4 price 0 1 2 5 prefarea NULL NULL 2 5 fullbase NULL NULL 2 5 bathrms NULL NULL 2 5 price NULL NULL 2 5 stories NULL NULL 2 5 recroom NULL NULL 2 5 lotsize NULL NULL 2 5 prefarea 4 1 2 5 price 4 2 2 5 price 3 2 2 5 stories 3 2 2 5 lotsize 3 1 2 5 bathrms 2 2 2 5 price 2 1 2 5 lotsize 2 1 2 5 stories 1 1 2 5 recroom 1 1 2 5 fullbase 0 1 2 6 fullbase NULL NULL 2 6 bathrms NULL NULL 2 6 garagepl NULL NULL 2 6 price NULL NULL 2 6 driveway NULL NULL 2 6 gashw NULL NULL 2 6 price 4 2 2 6 garagepl 4 1 2 6 bathrms 3 2 2 6 price 3 1 2 6 price 2 2 2 6 gashw 2 1 2 6 fullbase 1 2 2 6 driveway 0 1 2 7 airco NULL NULL 2 7 fullbase NULL NULL 2 7 bathrms NULL NULL 2 7 garagepl NULL NULL 2 7 price NULL NULL 2 7 stories NULL NULL 2 7 recroom NULL NULL 2 7 driveway NULL NULL 2 7 gashw NULL NULL 2 7 lotsize NULL NULL 2 7 bedrooms NULL NULL 2 7 airco 4 1 2 7 fullbase 4 1 2 7 stories 4 1 2 7 driveway 4 1 2 7 bathrms 3 1 2 7 price 3 1 2 7 gashw 3 1 2 7 lotsize 3 1 2 7 price 2 2 2 7 lotsize 2 1 2 7 bedrooms 2 1 2 7 garagepl 1 1 2 7 lotsize 1 1 2 7 recroom 0 1 2 8 price NULL NULL 2 8 price 1 1 2 8 price 0 1 2 9 price NULL NULL 2 9 price 1 1 2 9 price 0 1 2 10 garagepl 4 1 2 10 stories 4 1 2 10 lotsize 4 2 2 10 fullbase 3 2 2 10 bathrms 3 1 2 10 garagepl 3 1 2 10 price 3 1 2 10 lotsize 3 1 2 10 airco 2 1 2 10 garagepl 2 2 2 10 lotsize 2 1 2 10 prefarea 1 1 2 10 lotsize 1 1 2 10 bedrooms 0 1 2 10 airco NULL NULL 2 10 prefarea NULL NULL 2 10 fullbase NULL NULL 2 10 bathrms NULL NULL 2 10 garagepl NULL NULL 2 10 price NULL NULL 2 10 stories NULL NULL 2 10 lotsize NULL NULL 2 10 bedrooms NULL NULL 2 10 prefarea 4 1 2 10 bathrms 4 1 2 10 price 4 2 2 11 airco NULL NULL 2 11 bathrms NULL NULL 2 11 price NULL NULL 2 11 stories NULL NULL 2 11 lotsize NULL NULL 2 11 price 4 1 2 11 stories 4 1 2 11 bathrms 3 1 2 11 stories 3 1 2 11 price 2 1 2 11 lotsize 2 1 2 11 airco 1 1 2 11 price 0 1 2 12 fullbase NULL NULL 2 12 garagepl NULL NULL 2 12 price NULL NULL 2 12 lotsize NULL NULL 2 12 bedrooms NULL NULL 2 12 price 4 2 2 12 garagepl 4 1 2 12 lotsize 4 1 2 12 garagepl 3 1 2 12 lotsize 3 1 2 12 bedrooms 3 1 2 12 price 2 1 2 12 lotsize 2 2 2 12 fullbase 1 1 2 12 price 1 1 2 12 bedrooms 0 1 2 13 airco NULL NULL 2 13 fullbase NULL NULL 2 13 bathrms NULL NULL 2 13 garagepl NULL NULL 2 13 price NULL NULL 2 13 stories NULL NULL 2 13 gashw NULL NULL 2 13 lotsize NULL NULL 2 13 price 4 2 2 13 stories 4 1 2 13 gashw 4 1 2 13 airco 3 1 2 13 fullbase 3 1 2 13 price 3 2 2 13 garagepl 2 1 2 13 price 2 1 2 13 lotsize 2 2 2 13 fullbase 1 1 2 13 bathrms 1 1 2 13 lotsize 0 1 2 14 price NULL NULL 2 14 price 1 1 2 14 price 0 1 2 15 price 0 1 2 15 fullbase NULL NULL 2 15 garagepl NULL NULL 2 15 price NULL NULL 2 15 stories NULL NULL 2 15 lotsize NULL NULL 2 15 price 4 1 2 15 garagepl 4 1 2 15 price 3 1 2 15 stories 3 1 2 15 fullbase 2 1 2 15 lotsize 2 1 2 15 lotsize 1 1 2 16 airco NULL NULL 2 16 prefarea NULL NULL 2 16 fullbase NULL NULL 2 16 garagepl NULL NULL 2 16 price NULL NULL 2 16 stories NULL NULL 2 16 recroom NULL NULL 2 16 lotsize NULL NULL 2 16 bedrooms NULL NULL 2 16 airco 4 1 2 16 prefarea 4 1 2 16 price 4 2 2 16 stories 4 2 2 16 garagepl 3 1 2 16 price 3 1 2 16 lotsize 3 1 2 16 bedrooms 3 1 2 16 prefarea 2 1 2 16 fullbase 2 1 2 16 price 2 1 2 16 stories 2 1 2 16 lotsize 1 2 2 16 recroom 0 1 2 17 airco NULL NULL 2 17 prefarea NULL NULL 2 17 fullbase NULL NULL 2 17 bathrms NULL NULL 2 17 garagepl NULL NULL 2 17 price NULL NULL 2 17 gashw NULL NULL 2 17 lotsize NULL NULL 2 17 bedrooms NULL NULL 2 17 prefarea 4 1 2 17 garagepl 4 2 2 17 price 4 2 2 17 lotsize 4 1 2 17 airco 3 1 2 17 prefarea 3 1 2 17 price 3 2 2 17 bedrooms 3 1 2 17 bathrms 2 1 2 17 lotsize 2 1 2 17 gashw 2 1 2 17 fullbase 1 1 2 17 lotsize 1 1 2 17 lotsize 0 1 2 18 airco NULL NULL 2 18 bathrms NULL NULL 2 18 garagepl NULL NULL 2 18 price NULL NULL 2 18 recroom NULL NULL 2 18 stories NULL NULL 2 18 lotsize NULL NULL 2 18 gashw NULL NULL 2 18 recroom 4 1 2 18 stories 4 1 2 18 lotsize 4 1 2 18 airco 3 1 2 18 price 3 1 2 18 gashw 3 1 2 18 garagepl 2 1 2 18 recroom 2 1 2 18 bathrms 1 1 2 18 price 0 1 2 19 airco NULL NULL 2 19 bathrms NULL NULL 2 19 garagepl NULL NULL 2 19 price NULL NULL 2 19 recroom NULL NULL 2 19 gashw NULL NULL 2 19 lotsize NULL NULL 2 19 bedrooms NULL NULL 2 19 bathrms 4 1 2 19 price 4 1 2 19 gashw 4 1 2 19 garagepl 3 1 2 19 price 3 2 2 19 lotsize 3 2 2 19 bedrooms 3 1 2 19 airco 2 1 2 19 garagepl 2 1 2 19 price 2 1 2 19 bedrooms 2 1 2 19 bathrms 1 1 2 19 recroom 1 1 2 19 lotsize 0 1 2 20 airco 4 1 2 20 price 4 1 2 20 airco 2 1 2 20 lotsize 4 1 2 20 garagepl 2 1 2 20 fullbase 1 1 2 20 prefarea 0 1 2 20 bedrooms 4 1 2 20 airco NULL NULL 2 20 prefarea NULL NULL 2 20 fullbase NULL NULL 2 20 bathrms 3 1 2 20 bathrms NULL NULL 2 20 garagepl NULL NULL 2 20 garagepl 3 1 2 20 price 2 1 2 20 price NULL NULL 2 20 lotsize NULL NULL 2 20 price 3 1 2 20 gashw NULL NULL 2 20 bedrooms NULL NULL 2 20 lotsize 3 1 2 20 gashw 2 1 2 20 bathrms 1 1 2 21 fullbase 3 1 2 21 stories 3 1 2 21 lotsize 3 2 2 21 bedrooms 3 1 2 21 bathrms 2 1 2 21 stories 2 1 2 21 lotsize 2 1 2 21 bedrooms 2 1 2 21 garagepl 1 1 2 21 lotsize 1 1 2 21 prefarea NULL NULL 2 21 fullbase NULL NULL 2 21 bathrms NULL NULL 2 21 driveway 0 1 2 21 price NULL NULL 2 21 garagepl NULL NULL 2 21 stories NULL NULL 2 21 driveway NULL NULL 2 21 lotsize NULL NULL 2 21 bedrooms NULL NULL 2 21 prefarea 4 2 2 21 price 4 1 2 21 garagepl 4 1 2 21 stories 4 1 2 22 prefarea NULL NULL 2 22 airco NULL NULL 2 22 fullbase NULL NULL 2 22 bathrms NULL NULL 2 22 garagepl NULL NULL 2 22 price NULL NULL 2 22 stories NULL NULL 2 22 recroom NULL NULL 2 22 driveway NULL NULL 2 22 lotsize NULL NULL 2 22 bedrooms NULL NULL 2 22 garagepl 4 1 2 22 price 4 2 2 22 recroom 4 2 2 22 bedrooms 4 1 2 22 prefarea 3 2 2 22 airco 3 1 2 22 price 3 1 2 22 driveway 3 2 2 22 fullbase 2 1 2 22 stories 2 1 2 22 lotsize 2 2 2 22 bathrms 1 1 2 22 driveway 1 1 2 22 bedrooms 0 1 2 23 bathrms NULL NULL 2 23 garagepl NULL NULL 2 23 price NULL NULL 2 23 driveway NULL NULL 2 23 lotsize NULL NULL 2 23 fullbase 4 1 2 23 price 4 3 2 23 driveway 4 1 2 23 lotsize 4 2 2 23 prefarea 3 1 2 23 bathrms 3 1 2 23 garagepl 3 1 2 23 price 3 1 2 23 lotsize 3 1 2 23 bathrms 2 1 2 23 garagepl 2 1 2 23 lotsize 2 2 2 23 lotsize 1 2 2 23 airco 0 1 2 23 prefarea NULL NULL 2 23 airco NULL NULL 2 23 fullbase NULL NULL 2 24 price NULL NULL 2 24 stories NULL NULL 2 24 bedrooms NULL NULL 2 24 price 3 1 2 24 price 2 1 2 24 bedrooms 2 1 2 24 stories 1 1 2 24 price 0 1
Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.