import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;

class Day25
{
    /*
    public static void main( String [ ] args )
    {
        try
        {
            Connection conn = DriverManager.getConnection( "jdbc:odbc:HockeyDB" );

            Statement s = conn.createStatement( );

            ResultSet r = s.executeQuery(
                    "SELECT * FROM Hockey99Stats.txt " +
                    "WHERE (GOALS>=35) AND (ASSISTS>=35) " +
                    "ORDER BY GOALS DESC"
                    );

            while( r.next( ) )
            {
                System.out.println(
                        r.getString( "FIRSTNAME" ) + " " +
                        r.getString( "LASTNAME"  ) + " " +
                        r.getInt( "GOALS" ) + " " +
                        r.getInt( "ASSISTS" ) );
            }

        }
        catch( SQLException e )
        {
            e.printStackTrace( );
        }
    }
     * */

    public static void main( String [ ] args )
    {
        try
        {
            Connection conn = DriverManager.getConnection( "jdbc:odbc:BaseballStats" );
            Statement s = conn.createStatement( );

            ResultSet r = s.executeQuery(
                    "SELECT HR, yearID, nameFirst, nameLast " +
                    "FROM Batting, Master " +
                    "WHERE (HR>=50) AND (Batting.playerID=Master.playerID) " +
                    "ORDER BY HR DESC" );

            while( r.next( ) )
            {
                System.out.println(
                        r.getString( "nameFirst" ) + " " +
                        r.getString( "nameLast" ) + " " +
                        r.getInt( "HR" ) + " " +
                        r.getString( "yearID" ) );
            }
        }
        catch( SQLException e )
        {
            e.printStackTrace( );
        }
    }
}