SELECT COUNT (____ ID)
FROM teaches
WHERE semester = ’Spring’ AND YEAR = 2010;
If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.
Distinct
Count
Avg
Primary key
Quiz Recommendation System API Link  https://fresherbellquizapi.herokuapp.com/fresherbell_quiz_api
#  Quiz 

1
Discuss

Which of the following should be used to find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester.
Solution 
2
Discuss

All aggregate functions except _____ ignore null values in their input collection.
Solution 
3
Discuss

A Boolean data type that can take values true, false, and________
Solution 
4
Discuss

The ____ connective tests for set membership, where the set is a collection of values produced by a select clause. The ____ connective tests for the absence of set membership.
Solution 
5
Discuss

We can test for the nonexistence of tuples in a subquery by using the _____ construct.
Solution 
6
Discuss

Which of the following is used to find all courses taught in both the Fall 2009 semester and in the Spring 2010 semester .
Solution 
7
Discuss

Aggregate functions are functions that take a ___________ as input and return a single value.
Solution 
8
Discuss

The phrase “greater than at least one” is represented in SQL by _____
Solution 
9
Discuss

Which of the following should be used to find the mean of the salary ?
Solution 
#  Quiz 
Copyright © 2020 Inovatik  All rights reserved