What's wrong with my SQL code? It doesn't run. The SQL files are in the images attached. Queries should extract the answers directly. Use Employee.sql and Office.sql and write queries to extract the following information: # Get IDs of employees whose first name starts with “pa”, followed by three characters and then ends with “a”. Show the first name along with the employee ID. #SELECT FirstName FROM employees WHERE length(FirstName) = 6 and FirstName like ’Pa%s’;# How many employees at non-regional offices were hired after 2000? #SELECT count employees.hired_date, office.regionaloffice,FROM employeesINNER JOIN ON employees.EmployeeID=office.employeeidWHERE Hiredate>('2001-1-1') and title='accountant';# Get the Employee ID of the newest Account Rep who is working in a location with audit code=100. #SELECT employees.EmployeeIDFROM employeesINNER JOIN ON employees.EmployeeID=office.employeeidWHERE auditcode=100 and regionaloffice='no';# Get the average salaries for each of the following three groups: poor-performing account reps, poor-performing managers, and poor-performing trainees. Show the title and performance along with the average salaries. #select FirstName,avg(salary),performance='poor'from employeesgroup by title MYSQL dump 10.13Distrib 8.0.23, for Win64 (x86_64)--23-- Host: localhostDatabase: my_schema24---- Server version8.0.23/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;8 •/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;10 •/*!50503 SET NAMES utf8 */;11 •/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;12 •/*!40103 SET TIME_ZONE='+00:00' */;13 •/*!40014 SET MOLD UNIQUE CHECKS=@OUNIQUE CHECKS, UNIQUE CHECKS=0 */;14 •/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@0FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS= */;15 •/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;16 •/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;171819-- Table structure for table office"202122 •DROP TABLE IF EXISTS office';23 •/*!40101 SET @saved_cs_client@@character_set_client */;24 •/*!50503 SET character_set_client = utf8mb4 */;CREATE TABLE `office (* Location text,25 •26*Regionaloffice` text,* AuditCode int DEFAULT NULL272829) ENGINE=InnoDB DEFAULT CHARSET=latin1;30 •/*!40101 SET character_set_client = @saved_cs_client */;313233Dumping data for table office--34--3536 •LOCK TABLES office WRITE;37 •/*!40000 ALTER TABLE `office DISABLE KEYS */;38 •INSERT INTO office VALUES ('Atlanta', 'No',101), ('Boston', 'Yes',100), ('Chicago', 'No',110), ('New York', 'No',10139 •/*!40000 ALTER TABLE `office ENABLE KEYS */;40 •UNLOCK TABLES;41 •/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;4243 •/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;44 •/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;45 •/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;46 •/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;47 •/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;48 •/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;49 •/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;5051-- Dump completed on 2021-03-04 12:21:21 -- MYSQL dump 10.13 Distrib 8.0.23, for Win64 (x86_64)3-- Host: localhostDatabase: my_schema24-- Server version8.0.23/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;10 •/*!50503 SET NAMES utf8 */;11 •/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;12 •/*!40103 SET TIME_ZONE='+00:00' */;13 •/*!40014 SET @OLD_UNIQUE_CHECKS=@QUNIQUE_CHECKS, UNIQUE_CHECKS=0 */;14 •/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;15 •/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;16 •/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;1718--Table structure for table employees19--202122 •DROP TABLE IF EXISTS employees';23 •/*!40101 SET @saved_cs_client= @@character_set_client */;24 •/*!50503 SET character_set_client = utf8mb4 */;25 •e CREATE TABLE 'employees (26*EmployeeID int DEFAULT NULL,27* LastName text,28*FirstName text,*Location text,*Title text,*Gender text,29303132*Performance' text,*ManagerID text,*hired date date DEFAULT NULL,333435*salaries double DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;3637 •3839- Dumping data for table employees40414243 •LOCK TABLES employees WRITE;/*!40000 ALTER TABLE `employees DISABLE KEYS */;INSERT INTO employees VALUES (10000, 'Milgrom', 'Pamela', 'Boston', 'Manager', 'F','Average','88888','1999-11-2/*!40000 ALTER TABLE `employees ENABLE KEYS */;44 •45 •46 •47 •UNLOCK TABLES;48 •/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;4950 •/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;51 •/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;52 •/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;53 •/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;54 •/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;55 •/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;56 •/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;5758-- Dump completed on 2021-03-04 12:23:4859

Select queries return rows, from a table or a join of multiple tables, which match certain…

What's wrong with my SQL code? It doesn't run. The SQL files are in the images attached. Queries should extract the answers directly. Use Employee.sql and Office.sql and write queries to extract the following information: # Get IDs of employees whose first name starts with “pa”, followed by three characters and then ends with “a”. Show the first name along with the employee ID. # SELECT FirstName FROM employees WHERE length(FirstName) = 6 and FirstName like ’Pa%s’; # How many employees at non-regional offices were hired after 2000? # SELECT count employees.hired_date, office.regionaloffice, FROM employees INNER JOIN ON employees.EmployeeID=office.employeeid WHERE Hiredate>('2001-1-1') and title='accountant'; # Get the Employee ID of the newest Account Rep who is working in a location with audit code=100. # SELECT employees.EmployeeID FROM employees INNER JOIN ON employees.EmployeeID=office.employeeid WHERE auditcode=100 and regionaloffice='no'; # Get the average salaries for each of the following three groups: poor-performing account reps, poor-performing managers, and poor-performing trainees. Show the title and performance along with the average salaries. # select FirstName, avg(salary), performance='poor' from employees group by title

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE