Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do i fix this to get the question correct? Problems 7.1.7.7 | query.sql : 1Write your query below and then click Run Query to

image text in transcribed

How do i fix this to get the question correct?

Problems 7.1.7.7 | query.sql : 1Write your query below and then click "Run Query" to execute it. To save multiple Problem 1 queries, click the"con on the left 2 SELECT EMP NUM, EMP_LNAME, EMP_FNAME, EMP_INTIAL FROM EMPLOYEE Write the SQL code required to list the employee number, last name, first name, and middle initial of all employees whose last names start with Smith. In other words, the rows for both Smith and Smithfield should be included in the listing. Sort the results by employee number. Assume case sensitivity ERE EMP LNAME LIKE '%SMITH5, ORDERED BY EMP NUM TASK Complete Problem 1 above Problem 2 ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ORDERED BY EMP NUM' at line 3 Using the EMPLOYEE, J0B ,and PROJECT tables in the ChoConstructCo database, write the SQL code that will join the JOB, EMPLOYEE, and PROJECT tables using common attributes. Display the attributes shown in the results presented in Figure P7.2 - Write your query below and then click "Run Query to execute it. To save multiple queries the "+" icon on the left. SELECT EMP NUM, ENP LNAME, EMP FNAME, EMP INTIAL FROM EMPLOYEE WHERE

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

Database Design Application Development And Administration

Authors: Mannino Michael

5th Edition

0983332401, 978-0983332404

More Books

Students also viewed these Databases questions

Question

Evaluate 3x - x for x = -2 Answer:

Answered: 1 week ago

Question

What is group replacement? Explain with an example. (2-3 lines)

Answered: 1 week ago

Question

What does Processing of an OLAP Cube accomplish?

Answered: 1 week ago