New Activity
New Activity
All the activities
Play Unscramble Letters Game
1. all the conditions must be TRUE for a record to be displayed
N D A
2. limits or filters records retrieved from the database with a condition
H E W E R
3. combines information from multiple tables
N I J O
4. keyword identifying which keys (Primary Key and/or Foreign Key) to be used with JOIN
N O
5. only one of several conditions must be TRUE
R O
6. selects a table in the database
O F M R
7. simplifies query if a field falls within a known set of values
N I
8. means there is nothing in the data field
L L N U
9. Selects fields from the database to print out and perform operations on
E C S L T E
10. displays records with the same value in the summary rows
U B P G O Y R
11. limits or filters responses based on the value of aggregate functions
A I G H V N
12. gives us a running total of all the values of a selected numerical field
U M S
13. defines how we want the query data sorted
R O R B Y E D
14. sorts data in ascending order (default)
C A S
15. sorts data in descending order
C D E S
16. used to filter out duplicate rows of data
S T N I C I T D
17. tells us how many of a selected field there are
O T C U N
18. computes the average of a selected numerical field
R A G E V E A
19. allows comparisons with portions of the text of the result
E K I L
20. converts text to capital letters
P U R P E
21. converts text to non-capital letters
O W L R E
22. allows us to add a "mask" to our output for better presentation
C _ A O T R H
23. allows us to rename our output columns
L A S I A