Question: DO NOT USE OUTER JOIN OR INNER JOIN, ONLY EQUIJOIN 1. Using the tables below, display a list for agent name, city, order number, order

DO NOT USE OUTER JOIN OR INNER JOIN, ONLY EQUIJOIN

1. Using the tables below, display a list for agent name, city, order number, order date, order amount, salesman name and commission to find the agent who have placed orders by their salesman.

\begin{tabular}{clc} \multicolumn{3}{l}{ Department Table } \\ CODE & NAME & \\ \hline 57 & IT & 65000 \\ 63 & Finance & 15000 \\ 47 & HR & 240000 \\ 27 & RD & 55000 \\ 89 & QC & 75000 \end{tabular} Employee Table \begin{tabular}{cllc} IDNO & FNAME & LNAME & DEPT_ID \\ \cline { 1 - 2 } 127323 & Michale & Robbin & 57 \\ 526689 & Carlos & Snares & 63 \\ 843795 & Enric & Dosio & 57 \\ 328717 & Jhon & Snares & 63 \\ 444527 & Joseph & Dosni & 47 \\ 659831 & Zanifer & Emily & 47 \\ 847674 & Kuleswar & Sitaraman & 57 \\ 748681 & Henrey & Gabriel & 47 \\ 555935 & Alex & Manuel & 57 \\ 539569 & George & Mardy & 27 \\ 733843 & Mario & Saule & 63 \\ 631548 & Alan & Snappy & 27 \\ 839139 & Maria & Foster & 57 \end{tabular}

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 General Management Questions!

DO NOT USE OUTER JOIN OR INNER JOIN. ONLY USE EQUIJOIN. Using the tables below, dsplay a list for agent name, cly, order number, order date, order amount, salosman name and commission to find the...

Starter Text File: create table Worker ( WID number (9) Constraint pk_Wkr primary key, First_Name varchar2 (30) constraint nn_FN not null, Last_Name varchar2 (30) constraint nn_LN not null, MI...

Even if there are no real data in each table, write SQL statements by considering the following schema: Employee ( emplov id , employ _ name, email, hire _ date, salary, department _ id , manager _...

Populate.sql: Please show with steps on cmd SQL format Rem ******** dropping tables ************* DROP TABLE SALGRADE; DROP TABLE EMPLOYEE; DROP TABLE DEPT; Rem ******** create table DEPT...

LAB OVERVIEW Scenario and Summary Lab 5 will introduce the concept of multi-table JOINS in order to work with data in two or more related tables simultaneously. This lab may be completed using either...

Complete an information and physical level design of a database for Holt Distributors. Holt Distributors starts on page 337 with the general description, and goes through page 343. Read the entire...

This is SQL, I need help with these statements please!!! Here is everything needed to do it: Write SQL statements for questions given below for the PetStore database. Save your SELECT statements as...

(Answer all of the questions with a thumb up) (Using SQL Oracle to write). Tks 300% View Zoom Add Page Insert Table Chart Text Shape Media Commen Collaborate Format Docume 1. Create a query that...

/* ITEC 2120 DB Design & SQL Bowling EXTRA CREDIT 10 pts possible No column should have a heading such as EXPR1000 Use the Bowling database for all questions submit your SQL code to the dropbox!...

Using SQL Developer to execute the following queries. Script CREATE TABLE warehouses (wh_id NUMBER(2), location VARCHAR(12) ); INSERT INTO warehouses VALUES (10, 'Boston'); INSERT INTO warehouses...

Ritz-Carlton. The name alone evokes images of luxury and quality. As the first hotel company to win the Malcolm Baldrige National Quality Award, the Ritz treats quality as if it is the heartbeat of...

Arrange the following solutions in order of decreasing freezing point: 0.10 m Na3PO4, 0.35 m NaCl, 0.20 m MgCl2, 0.15 m C6H12O6, 0.15 m CH3COOH.

How to determine the optimal product mix with one constrained resource and a sales constraint?

2. The force of interest 8 is a function of time and at any time t, measured in years, is given by the formula: 8(t) = 0.02 +0.0020 8(t) = 0.03 +0.005t Osts5 5 st s 10 a) Calculate the discount...