Subqueries and SQL Review

Edit Answers
12345678910111213141516171819202122232425
Across
  1. 2. This function extracts text from a DATE
  2. 4. This clause is used to add a table to a query
  3. 5. This clause is used for a correlated subquery to link inner to outer queries
  4. 7. This is a query in the FROM or JOIN clauses
  5. 9. This clause limits results only of aggregate functions
  6. 11. This clause specifies the first table of a query
  7. 12. A query inside another query
  8. 13. This goes between the alias and the column name
  9. 15. These are used to group a subquery vertically
  10. 19. This separates fields in the SELECT and ORDER BY clauses
  11. 20. Combined this keyword and AS to make a query you can reference throughout the query
  12. 22. The error when you can't tell what table a column goes to
  13. 23. What you call a renamed table
  14. 24. This clause cannot be used in subqueries only outer queries
  15. 25. This function type is great for scalar queries
Down
  1. 1. Too many rows in the resulting query because incorrect JOIN
  2. 3. A reference in a table to another table’s entire row
  3. 6. Only used at the VERY end of the query
  4. 8. This clause limits results by design
  5. 10. The current server time
  6. 14. Shorthand for extracting information from DATE types
  7. 16. This function returns a date from supplied text
  8. 17. A subquery that returns a table with one row and column
  9. 18. Clause used to organize results when using aggregate functions
  10. 19. This function returns the number of rows in the result set
  11. 21. A subquery that references the outer query and the inner query
  12. 25. How you rename a column