Learn SQL Database Programming

Learning how to use the AND and OR operators

Some additional expression operators that you can use in MySQL include AND and OR. These are considered logical operators.

You can add additional WHERE clauses as needed using the AND clause. If you want to see all records where g_all is greater than 40 and g_all didn't equal g_batting, you can execute the following query:

USE lahmansbaseballdb;SELECT playerid, g_all, g_batting, g_defense FROM appearancesWHERE g_all > 40 AND g_all <> g_batting; 

You can also add additional WHERE clauses as needed using the OR clause. If you want to see all records where g_all is greater than 40 OR g_defense is greater than 30, you can execute the following query:

USE lahmansbaseballdb;SELECT playerid, g_all, ...