Question: 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

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Lab 02: Data Manipulation Part 1 1- Copy and paste the content of the text file Lab02_Data.txt into any SQL Editor, then execute it. This code will create the table Agents and insert sample data into...

Preliminary Tasks: Task 1 In this Lab, it's assumed that you have already created the Agents table and inserted sample data into it. If you don't have it, or if you are using Oracle Live SQL, you...

D O NO T Ta KE IF YOU CANNOT ANSWEAR ALL THE QUESTION AS SUPPOSED OR I WILL RATE UNHELPFUL AND REPORT FOR PLAG Peru Domestic: a bond is issued in the US Global: a bond is issued in the US and foreign...

Yego Domestic: a bond is issued in the US Global: a bond is issued in the US and foreign markets Eurobonds: a bond denominated in USD is issued in the foreign market. You need to estimate the...

Scenario and Summary The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model (tables, constraints, and relationships). As part of the...

Narrative/Case Study For this lab, you will be creating SQL statements to build a series of relational tables, using SQL CREATE statements in a script file format for the Student Database. You will...

need the sql solution the question relates to the data model shown below in the picture. the sql code needs to be written in regards to the example data model given below ecerything there nothing...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Need help with this. Post Lab #03: Recipes Revisited, the Mad Libs Version Post Lab 03 Anyone crammed into a car with (a variable number of) siblings has probably played the Mad Libs word game. A...

What general cost trade-offs are associated with the firms level of short- term financing? How do these costs behave when a firm substitutes short-term financing for long- term financing? How would...

Write a bash script to take two integers as arguments and apply all arithmetic operations on them and then print the output on a file named OUTPUT . NOTE: Every time you run the script the previous...

The following formula is for R Rfree = a + b 1 ( Rm Rfree ) + b 2 ( SMB ) + b 3 ( HML ) + in the Fama French 3 - Factor model. the Fama French 4 - Factor model. the Fama French 5 - Factor model. a...

ed Test This test has a time limit of 20 minutes.This test will save and submit automaticaly when the time expires temptsNot ultiple Warnings appear when half the time, 5 minutes, 1 minute, and 30...

3. Define the attributions we use to explain behavior

2. Describe how you managed an impression of yourself in a face-to-face interaction and a mediated one. Describe your conscious preparations for this impression management, and then describe the...

1. Describe how our personal perspective on the world influences our communication