IST 210 Reading Assignment 4 (25 points)
1.
What MySQL clause is considered a “simple condition”? (2 points)
WHERE clause
2.
Give three (3) examples of a Comparison Operator used in MySQL commands? (3 points)
= equal to
< less than
> Greater than
3.
What operator in a MySQL command do you use to determine if a value is between two other values and is inclusive of the values (WITHOUT using an AND condition)? (2 points)
between
4.
List three (3) arithmetic operators that you can use to perform computations in MySQL queries? (3 points)
+ addition
* Multiplication
/ Division
5.
What clause in a MySQL query allows you to sort the results of the query? (2 points)
Order by clause
6.
List three (3) of the aggregate functions that you can apply to groups of rows in MySQL? (3 points)
AVG calculates value
COUNT determines number of rows
MAX determines maximum value 7.
What MySQL Operator is used to eliminate duplicate values in a MySQL query? (2 points)
Distinct
8.
For a nested query in MySQL explain the following: (5 points)
a.
What is Subquery?
A query placed inside of another query
b.
What is the outer query?
Uses the subquery results
c.
Explain how the subquery and outer query evaluate the data to find the results? i.e. which one is evaluated first.
