SIGN IN
SIGN UP
Login to your account
Username or Email *
Password *
Remember Me
Forgot your password?
Forgot your username?
Menu
Home
Courses
Administrator
Flow Builder
Apex Beginner
Apex Intermediate
Integration
LWC
Projects
Challenge
Recap Quiz
Sign Up
Live Courses
Interview
Sign In
Apex Beginner Progress | ( Lessons)
%
Lesson: 16 AVG & GROUP BY
Query
Query Results
Video
Query
SELECT StageName, AVG(Amount) FROM Opportunity GROUP BY StageName
Query Results
Video
Video does not exists.
Prev
You need to login to have access to the quizzes.
Next
Mastered by 169 users.
Apex Beginner
A. Apex Fundamentals
(23 lessons)
01 | Introduction
02 | Debug
03 | Comments
04 | Data Types
05 | Variables
06 | String Methods
07 | Integer Methods
08 | Decimal Methods
09 | Date Methods
10 | Datetime Methods
11 | Time Methods
12 | Math Class & Methods
13 | Arithmetic Operators
14 | Booleans
15 | Assignment Operators
16 | Comparison Operators
17 | Logical Operators
18 | If ... Else
19 | Ternary Operator
20 | Switch
21 | For Loop
22 | While Loop
23 | Break/Continue
B. Apex Collections
(6 lessons)
01 Lists
02 Sets
03 Maps
04 Collections
05 Parameterized Typing
06 List of sObjects
C. SOQL
(33 lessons)
01 SELECT & FROM
02 WHERE
03 ORDER BY
04 LIMIT
05 SELECT, FROM, WHERE, ORDER BY, LIMIT
06 AND & OR
07 COUNT()
08 SUM()
09 SUM() and GROUP BY
10 MAX()
11 MAX() & GROUP BY
12 MIN()
13 MIN() & GROUP BY
14 LIKE (A%)
15 AVG()
16 AVG & GROUP BY
17 IN() & NOT IN()
18 COUNT_DISTINCT()
19 INCLUDES()
20 EXCLUDES()
21 OFFSET
22 Comparison Operators
23 Parent-to-Child Query
24 Child-to-Parent Query
25 FIELDS()
26 Create a Query List
27 HAVING()
28 | Relative Date Filter Reference
29 | ActivityHistories
30 | Querying Scheduled Jobs
31 | Counting Contacts for Accounts
32 | Fetching Opportunities by Calendar Year
You need to complete all the quizzes before certification.
You need to complete all the quizzes before certification.
Go to top