To retrieve students aged 20 or older, you can use:

SELECT * FROM students WHERE age > 20

SELECT * FROM students WHERE age >= 20

SELECT * FROM students WHERE age

To find the average age of students, which SQL statement should you use?

SELECT AVERAGE(age) FROM students

In SQL, the HAVING clause is used:

To filter grouped rows based on a condition

To filter rows based on a condition

To group rows based on a specific column

To sort rows in ascending order

To retrieve the list of students who have enrolled in courses, you can use:

SELECT * FROM students JOIN enrollments WHERE students.student_id = enrollments.student_id

SELECT FROM students WHERE EXISTS (SELECT FROM enrollments WHERE students.student_id = enrollments.student_id)

SELECT * FROM students WHERE students.student_id = enrollments.student_id

To retrieve a list of students who have not enrolled in any courses, which SQL statement should you use?

SELECT * FROM students JOIN enrollments WHERE students.student_id = enrollments.student_id and enrollments.enrollment_id IS NULL

SELECT FROM students WHERE students.student_id = enrollments.student_id)

SELECT * FROM students WHERE students.student_id = enrollments.student_id

To retrieve the course with the highest number of credits, you can use:

SELECT course_name FROM courses WHERE credits = (SELECT MAX(credits) FROM courses)

SELECT MAX(credits) FROM courses

SELECT MIN(credits) FROM courses

SELECT AVG(credits) FROM courses

In SQL, what is the purpose of the AVG function?

To calculate the average of values in a column

To calculate the sum of values in a column

To calculate the median of values in a column

To calculate the maximum value in a column

To retrieve the list of courses along with the number of students enrolled in each course, which SQL statement should you use?

SELECT course_name, COUNT(student_id) FROM courses JOIN enrollments WHERE courses.course_id = enrollments.course_id GROUP BY course_name

SELECT course_name FROM courses JOIN enrollments courses.course_id = enrollments.course_

SELECT course_name, SUM(enrollments) FROM courses JOIN enrollments courses.course_id = enrollments.course_id GROUP BY course_name

SELECT course_name, AVG(student_id) FROM courses JOIN enrollments courses.course_id = enrollments.course_id GROUP BY course_name

In SQL, what does the MAX function return when used with a text column (e.g., course_name)?

An error, as MAX cannot be used with text columns

The length of the longest text value

The first text value in alphabetical order

The last text value in alphabetical order

To retrieve the list of students who are 21 years old and enrolled in courses, you can use:

SELECT * FROM students WHERE age = 21 AND student_id IN enrollments

SELECT * FROM students WHERE age = 21 AND student_id IN (SELECT student_id FROM enrollments)

SELECT * FROM students WHERE age = 21 AND student_id = (SELECT student_id FROM enrollments)

SELECT FROM students WHERE age = 21 AND EXISTS (SELECT FROM enrollments WHERE students.student_id = enrollments.student_id)

Coding Fintech Final - Fall

Quiz

•

Computers

•

12th Grade

•

Practice Problem

•

Medium

David Turner

Used 3+ times

FREE Resource

"first_name", "last_name"

first_name, last_name

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

25 questions

Computer Internal Components Study Guide

Quiz

•

KG - Professional Dev...

25 questions

Future Technologies Quiz

Quiz

•

6th Grade - University

25 questions

PTS DATABASE (2)

Quiz

•

12th Grade

25 questions

Networking 1 Chapter 6 Test

Quiz

•

9th - 12th Grade

25 questions

CSD Unit 1 Problem Solving

Quiz

•

9th - 12th Grade

25 questions

Bimbel Teori Kejuruan TKJ 03

Quiz

•

12th Grade

26 questions

HTML Forms - CIW SDA Lesson 6

Quiz

•

9th Grade - University

25 questions

JavaScript Certification Quiz

Quiz

•

12th Grade

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

18 questions

[AP CSP] JavaScript Programming Lesson 2025-2026

Lesson

•

9th - 12th Grade

Coding Fintech Final - Fall

30 questions

What SQL command is used to select data from a table?

Which SQL clause specifies the table(s) from which to retrieve data?

What SQL clause is used to filter data based on a specific condition?

What SQL clause is used to sort the result set in ascending or descending order?

To retrieve all columns from the students table, what should you use after SELECT?

What SQL clause is used to limit the rows returned in the result set?

To select only the first_name and last_name columns from the students table, what should you specify after SELECT?

What SQL clause is used to group rows based on a specific column's values?

To count the number of students in each gender category, you can use:

Which SQL function is used to calculate the sum of values in a numeric column?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers