Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Make an SQL query that Display all employees, in alphabetical order, last name, first name, job description, publisher name Publishers pub_id pub_name city state country

Make an SQL query that

Display all employees, in alphabetical order, last name, first name, job description, publisher name

Publishers
pub_id pub_name city state country
0736 New Moon Books Boston MA USA
0877 Binnet & Hardley Washington DC USA
1389 Algodata Infosystems Berkeley CA USA
1622 Five Lakes Publishing Chicago IL USA
1756 Ramona Publishers Dallas TX USA
9901 GGG&G Mnchen Germany
9952 Scootney Books New York NY USA
9999 Lucerne Publishing Paris France
Employees
emp_id fname minit lname job_id job_lvl pub_id hire_date
PMA42628M Paolo M Accorti 13 35 0877 8/27/2002
PSA89086M Pedro S Afonso 14 89 1389 12/24/2000
VPA30890F Victoria P Ashworth 6 140 0877 9/13/2000
H-B39728F Helen Bennett 12 35 0877 9/21/1999
L-B31947F Lesley Brown 7 120 0877 2/13/2001
F-C16315M Francisco Chang 4 227 9952 11/3/2000
PTC11962M Philip T Cramer 2 215 9952 11/11/1999
A-C71970F Aria Cruz 10 87 1389 10/26/2001
AMD15433F Ann M Devon 3 200 9952 7/16/2001
ARD36773F Anabela R Domingues 8 100 0877 1/27/2003
PHF38899M Peter H Franken 10 75 0877 5/17/2010
PXH22250M Paul X Henriot 5 159 0877 8/19/2010
CFH28514M Carlos F Hernandez 5 211 9999 4/21/1999
PDI47470M Palle D Ibsen 7 195 0736 5/9/2003
KJJ92907F Karla J Jablonski 9 170 9999 3/11/2008
KFJ64308F Karin F Josephs 14 100 0736 10/17/2002
MGK44605M Matti G Karttunen 6 220 0736 5/1/2009
POK93028M Pirkko O Koskitalo 10 80 9999 11/29/2007
JYL26161F Janine Y Labrune 5 172 9901 5/26/2001
M-L67958F Maria Larsson 7 135 1389 3/27/2002
Y-L77953M Yoshi Latimer 12 32 1389 6/11/1999
LAL21447M Laurence A Lebihan 5 175 0736 6/3/2000
ENL44273F Elizabeth N Lincoln 14 35 0877 7/24/2000
PCM98509F Patricia C McKenna 11 150 9999 8/1/1999
R-M53550M Roland Mendel 11 150 0736 9/5/2001
RBM23061F Rita B Muller 5 198 1622 10/9/2007
HAN90777M Helvetius A Nagy 7 120 9999 3/19/2003
TPO55093M Timothy P O'Rourke 13 100 0736 6/19/1998
SKO22412M Sven K Ottlieb 5 150 1389 4/5/2001
MAP77183M Miguel A Paolino 11 112 1389 12/7/2002
PSP68661F Paula S Parente 8 125 1389 1/19/2004
M-P91209M Manuel Pereira 8 101 9999 1/9/1999
MJP25939M Maria J Pontes 5 246 1756 3/1/1999
M-R38834F Martine Rance 9 75 0877 2/5/2002
DWR65030M Diego W Roel 6 192 1389 12/16/2001
A-R89858F Annette Roulet 6 152 9999 2/21/2000
MMS49649F Mary M Saveley 8 175 0736 6/29/2009
CGS88322F Carine G Schmitt 13 64 1389 7/7/2002
MAS70474F Margaret A Smith 9 78 1389 9/29/1998
HAS54740M Howard A Snyder 12 100 0736 11/19/1998
MFS52347M Martin F Sommer 10 165 0736 4/13/2000
GHT50241M Gary H Thomas 9 170 0736 8/9/1998
DBT39435M Daniel B Tonini 11 75 0877 1/1/2000
Jobs
job_id job_desc min_lvl max_lvl
1 New Hire - Job not specified 10 10
2 Chief Executive Officer 200 250
3 Business Operations Manager 175 225
4 Chief Financial Officier 175 250
5 Publisher 150 250
6 Managing Editor 140 225
7 Marketing Manager 120 200
8 Public Relations Manager 100 175
9 Acquisitions Manager 75 175
10 Productions Manager 75 165
11 Operations Manager 75 150
12 Editor 25 100
13 Sales Representative 25 100
14 Designer 25 100

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Larry Ellison Database Genius Of Oracle

Authors: Craig Peters

1st Edition

0766019748, 978-0766019744

More Books

Students also viewed these Databases questions