document.write("  <div align=left>     <HR> <H3>The Group-By Feature</H3> One of the most powerful and time saving features of the SDQL is the group-by feature. This allows you to compare results for several related situations with a single query. There are two ways in which to instantiate a group-by:  implicitly by using a parameter without a condition  and explicitly by using a comma delimited set of conditions. <p>  To see the average number of three pointers made for each NBA team in the 2007 season use the SDQL: <BR> <em> <a href=http://SportsDataBase.com/nba.py/query?text=Average%28three%20pointers%20made%29%40team%20and%20season%3D2007>Average(three pointers made)@team and season=2007</a> </em> <BR> Note that since the team parameter is not set to any value,  each value occuring in the database is returned.   <p> An explicit group-by is performed by using a comma delimited set of values. To see how NFL teams do after scoring fewer than 3, 7, 10, and 14 points use the SDQL: <BR> <em> <a href=http://SportsDataBase.com/nfl.py/query?text=p%3Apoints%20%3C%203%2C%207%2C%2010%2C%2014>p:points &lt; 3, 7, 10, 14</a> </em> <p> SDQL also allows ranges of values to be groups as per: <BR> <em> <a href=http://SportsDataBase.com/nfl.py/query?text=0%2C%2010%2C%2014%20%3C%3D%20p%3Apoints%20%3C%2010%2C%2014%2C%2021>0, 10, 14 &lt;= p:points &lt; 10, 14, 21</a> </em> <BR> <p> The implicit and explicit group-by methods can be combined.   To add the League results to the above query for average number of three pointers made use the SDQL: <BR> <em> <a href=http://SportsDataBase.com/nba.py/query?text=Average%28three%20pointers%20made%29%40team%2C1%20and%20season%3D2007>Average(three pointers made)@team,1 and season=2007</a> </em>    <HR>     </div>");