Subquery and Review

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