Long description

Statement 1: SELECT i s b n 10 comma title FROM books WHERE copyrightYear greater than 2010. WHERE is labeled SQL keyword that indicates to return only those records whose data matches the criteria expression. copyrightYear greater than 2010 is labeled Expressions take form: field operator value. Statement 2: SELECT i s b n 10 comma title FROM books WHERE category equals open single quote Math close single quote AND copyrightYear equals 2014. category equals open single quote Math close single quote is labeled Comparisons with strings require string literals (single or double quote).