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