Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Lab 03: Data Manipulation In this Lab we assume that you already have the Agents table with sample data inserted into it. If you don't
Lab 03: Data Manipulation In this Lab we assume that you already have the Agents table with sample data inserted into it. If you don't have that table or you are using the Oracle Live SQL, you will need to create the Agents table and add data to it by copying and pasting the content of the file "Lab02_Data.txt" into an SQL Editor, then execute it. Provide the SQL statements that answer the following tasks: 1- How many agents are there? 2- What is the minimum, the average, and the maximum salaries of all agents? 3- What is the number of agents living in New York state and the sum of their salaries? 4- How many agents have NULL email addresses? 5- How many agents work in the branch B002 and have salaries greater than $40000? 6- How many different branches are there? 7- What is the number of agents in each state? 8- What is the number of agents in each branch and the average of their salaries
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