Higher DDD - Using queries in queries
Presentation
•
Computers
•
11th Grade
•
Easy
G Alexander-Doyle
Used 1+ times
FREE Resource
8 Slides • 5 Questions
1
2
3
4
Multiple Select
Select all statements that correctly describe aggregate functions.
They return a value when run on a row or set of rows.
They can only be used in Microsoft Excel, not in databases.
They perform calculations such as sum, average, min, and max.
They are used to filter rows based on a condition.
5
6
Multiple Choice
Which aggregate function would you use to find the smallest value in a column?
SUM()
MAX()
MIN()
AVG()
7
Multiple Choice
Which of the following is NOT a common aggregate function used in databases?
AVG()
COUNT()
MIN()
FIND()
8
9
10
11
12
Open Ended
How confident do you feel about incorporating data from a query containing an aggregate function into another query after this lesson?
13
Multiple Choice
What is one way you can use data from a database query in another query?
By using subqueries
By creating a new table
By exporting data to a spreadsheet
By deleting the original query
Show answer
Auto Play
Slide 1 / 13
SLIDE
Similar Resources on Wayground
6 questions
MATEMÁTICA
Presentation
•
11th Grade
7 questions
SEL - SMART Goals
Presentation
•
12th Grade
12 questions
CARACTERISTICAS DEL MOTOR ELÉCTRICO
Presentation
•
10th Grade
10 questions
Databases Introduction
Presentation
•
10th Grade
10 questions
The Last Assignment - Speaking task
Presentation
•
11th Grade
11 questions
Thanksgiving Trivia
Presentation
•
11th Grade
11 questions
MATEMÁTICA I
Presentation
•
11th Grade
Popular Resources on Wayground
24 questions
PBIS-HGMS Day 10
Quiz
•
6th - 8th Grade
10 questions
HCS SCI 03 Summer School Review 3
Quiz
•
3rd Grade
11 questions
Home Scope
Quiz
•
7th - 8th Grade
15 questions
HCS SCI 05 Summer School Assessment 3 Review
Quiz
•
5th Grade
35 questions
Lufkin Road Middle School Student Handbook & Policies Assessment
Quiz
•
7th Grade
18 questions
Geo 11.3 Area of Circles and Sectors
Quiz
•
9th - 11th Grade