Logo 
Search:

SQL FAQ

Submit Interview FAQ
Home » Interview FAQ » SQLRSS Feeds

Using today's TEAMSTATS table, write a query to determine who is batting under .25

  Shared By: Shruti Sharma    Date: Dec 21    Category: SQL    Views: 1229

Answer:

Using today's TEAMSTATS table, write a query to determine who is batting under .25. (For the baseball-challenged reader, batting average is hits/ab.)

INPUT:

SELECT NAME FROM TEAMSTATS
WHERE (HITS/AB) < .25;

OUTPUT:

NAME
--------------
HAMHOCKER
CASEY

Share: 
 


Related Topics:

Your Comment
  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].


Tagged: