SQL ch3 review Matching
| You form ___ ___ by connecting two or more simple conditions using the AND, OR and NOT operators. |
| In SQL, you specify the results order by using the __ clause. |
| 34.SQL has special functions, called ___ ___ to calculate sums, averages, counts, max values, and min values. |
| Next you type the word FROM followed by the name of the table that contains the data you need to query. This portion of the command is called? |
| 34.It is possible to place one query inside another. The inner query is called a ____; the subquery is evaluated __. |
| A ___ has this form: column name, comparison operator, and then either another column name or a value |
| An ____ which consists of the IN operator followed by a collection of values, provides a concise way of phrasing certain conditions. |
| Finally, after the word WHERE you list any conditions that apply to the data you want to retrieve. This optional portion of the command is called the? |
| 34.The column on which data is to be sorted is called a ____ or simply a ___. |
| A ____ is simply a question represented in a way that the DBMS can understand. |
0:00
