Re: Fun with SQL

Ron Jeffries wrote:

>On Tuesday, June 22, 2004, at 3:55:33 PM, Frohnhofer, James wrote:
>  
>
>
>>        B) its primary metaphor of rows, tables and keys is consistent, 
>> pervasive
>>and easily grasped.
>>    
>>
>
>On what planet is it true that SQL has been successful with real end users?
>I don't think I've /ever/ encountered real end users who weren't getting
>their SQL done by DB specialists.
>  
>
And sometimes not easily grasped by DB specialists.

Show me the SQL for this: "I need to see all students who have had three 
or more tardies, and send the student a report of those tardies. Then I 
need to make sure I don't resend a tardy report to the same student, 
unless they've accrued additional tardies."

Granted, it's a long couple of sentences, but I think the concept is 
pretty straightforward in humanville. Getting the right SQL statement 
(vs. one that /seems/ right but really isn't) can be tricky (or at least 
it was to a dunderhead like me :-)

-- 
Chris
http://clabs.org/blogki



------------------------ Yahoo! Groups Sponsor --------------------~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/nhFolB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
     http://groups.yahoo.com/group/pragprog/

<*> To unsubscribe from this group, send an email to:
     pragprog-unsubscribe-hHKSG33TihhbjbujkaE4pw@xxxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
     http://docs.yahoo.com/info/terms/