two built in functions in sql

2 ways to select data involving more than one table

keyword used to remove a table and all of its contents from a database

symbol used to select all the columns of a table

symbol used in sql to determine if 2 items are equal

keyword used in a select statement to match an item from a list/set

Wildcard character that can match multiple characters

keyword that facilitates searches on patterns

Wildcard character that matches a single character

A select statement usually consists of