Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please fill in the blanks with the information table below. Note: it is mysql codes and be sure to choose the right ones. thanks EMP

image text in transcribed

please fill in the blanks with the information table below.

Note: it is mysql codes and be sure to choose the right ones.

thanks

EMP 04', 'Smith riel Jose' EMP William B", "22-Jun-15 EMP IOB CODE 502 EMP JOB CODE EMP NUM SELECT EMP EMP NUM 02 FROM EMP EMP LNAME senior AND EMP FNAME David' EMP HIREDATE '12Nul 99 AND JOB CODE TABLE EMP H. (EMP TITLE EMP VARCHAR A50 News, John '08-Nov-14 "Progra mmer', '502'): 2 Ju-9), Lawyer", "500"): L SELECT FROM EMP EMP LNAME J. SELECT EMP LNAME, EMP FNAME FROM EMP EMP LNAME EMP LNAME FROM EMP EMP o, ALTER TABLE EMP COLUMN EMPLINITIALEMI' MIDDLE INITIAL( EMP LNAME P. SELECT FROM EMP NUMBER, EMP LNAME EMPJoB coDE) 2. DATE CODE 4, INSERT SELECT 9, VARCHAR CHAR VALUE FROM 2, SET WHERE LETE RAI 19. LIKE AND COMMII 20, AS ALTER 21 ORDER MY 22, LIKE AFTER 127 CHANGE CREATE 20 DESC 25 DESCRIIE COLUMNS 30, GROUP BY

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

Step: 3

blur-text-image

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

Semantics In Databases Second International Workshop Dagstuhl Castle Germany January 2001 Revised Papers Lncs 2582

Authors: Leopoldo Bertossi ,Gyula O.H. Katona ,Klaus-Dieter Schewe ,Bernhard Thalheim

2003rd Edition

3540009574, 978-3540009573

Students also viewed these Databases questions