Question
18- List full details of agents with empty (NULL) email addresses. 19- Display the total number of agents. Note: Use the COUNT aggregate function. 20-
18- List full details of agents with empty (NULL) email addresses.
19- Display the total number of agents. Note: Use the COUNT aggregate function.
20- Display the minimum, the average, and the maximum salaries of all agents.
21- Display the number of agents living in New York State (NY) and the sum of their salaries.
22- Display the number of agents who work in the branch B002 and have salaries greater than $40000.
23- Display, in each state, the number of agents sorted in the descending order.
24- Display the number of agents in each branch and the sum of their salaries.
25- In each branch, display the number of agents living in New Jersey (NJ) or New York (NY) states and the average of their salaries.
26- Exclude, from the list you displayed in the previous task, the branches that have salary averages less than $34000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database Processing
Authors: David M. Kroenke
12th Edition International Edition
1292023422, 978-1292023427
