Great Data Mining blog post on DM SQL

Marcos has a great post on "The SQL of Analytics 1 - Data Mining" on the Oracle Data Mining blog (link to blog):

"What do we get when we combine the power of SQL with advanced analytics? The answer: a revolution. The Oracle RDBMS has added, over recent releases, support for advanced analytics to the SQL vocabulary..."

Simple Prediction Query
Question:

Select all customers who have a high propensity to attrite (> 80% chance)

SQL Query:

      SELECT A.cust_name, A.contact_info
      FROM   customers A
      WHERE  PREDICTION_PROBABILITY(tree_model, ‘attrite’ 
                                    USING A.*) > 0.8


Follow this link for the full post.