Answered step by step
Verified Expert Solution
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
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 |
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 |
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
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