Question
a.
select job, sum(sal) from emp where sum(sal) > 2500 and comm is null;
b.
select job, sum(sal) from emp where comm is null group by job having sum(sal) > 2500;
c.
select job, sum(sal) from emp where sum(sal) > 2500 and comm is null group by job;
d.
select job, sum(sal) from emp group by job having sum(sal) > 2500 and comm is not null;
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?
Similar Questions
Discover Related MCQs
Q. Which one of the following is used to define the structure of the relation ,deleting relations and relating schemas ?
View solution
Q. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
View solution
Q. Create table employee (name varchar ,id integer)
What type of statement is this ?
View solution
Q. Select * from employee
What type of statement is this?
View solution
Q. The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.
View solution
Q. An attribute A of datatype varchar(20) has the value “Avi” . The attribute B of datatype char(20) has value ”Reed” .Here attribute A has ____ spaces and attribute B has ____ spaces.
View solution
Q. To remove a relation from an SQL database, we use the ______ command.
View solution
Q. Delete from r; r – relation
This command performs which of the following action ?
View solution
Q. Insert into instructor values (10211, ’Smith’, ’Biology’, 66000);
What type of statement is this ?
View solution
Q. Updates that violate __________ are disallowed.
View solution
Q.
Name
Annie
Bob
Callie
Derek
Which of these query will display the the table given above ?
View solution
Q. Select ________ dept_name
from instructor;
Here which of the following displays the unique values of the column ?
View solution
Q. The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
View solution
Q. Select ID, name, dept name, salary * 1.1
where instructor;
The query given below will not give an error. Which one of the following has to be replaced to get the desired output?
View solution
Q. The ________ clause is used to list the attributes desired in the result of a query.
View solution
Q. Select name, course_id
from instructor, teaches
where instructor_ID= teaches_ID;
This Query can be replaced by which one of the following ?
View solution
Q. Select * from employee where salary>10000 and dept_id=101;
Which of the following fields are displayed as output?
View solution
Q. Which of the following statements contains an error?
View solution
Q. Insert into employee _____ (1002,Joey,2000);
In the given query which of the keyword has to be inserted ?
View solution
Q. SELECT * FROM employee WHERE dept_name="Comp Sci";
In the SQL given above there is an error . Identify the error .
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
.png)
