Based on the ERD below, display the first name, last name and employee initial of anyone whose first name starts with “A”. (Hint: You will use a “Like” phrase.) ASSIGNMENTV ASSIGN_NUMASSIGN_DATEPROJ_NUMEMP_NUMASSIGN_JOBASSIGN_CHG_HRASSIGN_HOURSASSIGN_CHARGEJOBV JOB_CODEJOB_DESCRIPTIONJOB_CHG HOURJOB_LAST_UPDATEEMPLOYEEV EMP_NUMPROJECTV PROJ_NUMEMP_LNAMEEMP_FNAMEEMP_INITIALEMP_ HIREDATEJOB_CODEEMP_VEARSPROJ_NAMEPROJ_VALUEPROJ_BALANCEEMP_NUM

1) Query to display first name, last name, employee initial whose first name starts 'A' > SELECT EMP_FNAME,EMP_LNAME,EMP_INITIAL FROM EMPLOYEE WHERE EMP_FNAME LIKE "A%";Answer: > SELECT EMP_FNAME,EMP_LNAME,EMP_INITIAL FROM EMPLOYEE WHERE EMP_FNAME LIKE "A%";

Answered: Based on the ERD below, display the…

Engineering

Computer Engineering

Based on the ERD below, display the first name, last name and employee initial of anyone whose first name starts with “A”. (Hint: You will use a “Like” phrase.)

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: Write a SQL query that displays the number of customers who born on the 16th day of a month . Write…

A: 1. select count(customerID) from Customers where to_char(custDOB,'DD') = 16; 2. select customerID…

Q: Explain the difference between the WHERE and HAVING clause.

A: Where filters the record from the table. Having filter the record from the group. Where clause can…

Q: List the first name and last name of all authors. Concatenate the first and last names so that the…

A: Concat() function : This function in SQL joins string into one, maximum string which it can take as…

Q: Find the rep number, last name, and first name of each sales rep who represents at least one…

A: The, answer has given below:

Q: Report the name of the customer who bought the most expensive product. sql

A: According to the information given:- We have to write query in order to get the name of the…

Q: Display employees where the first name or last name starts with S. using sql plus hr user

A: To select data from a database, SELECT statement are used. The data is saved in a result table…

Q: List the item ID as ITEM_ID and description as ITEM_DESC for all items. The descriptions should…

A: Actually, A database is a collection of information that is organized so that it can be easily…

Q: Show all name and phone numbers of students and the type of donation they received including any…

A: Show all name and phone numbers of students and the type of donation they received including any…

Q: Explain the one way selection form.

A: One-way selection form: It performs some indicated action if a condition is true. If the condition…

Q: When should a subquery be nested inside of a HAVING clause?

A: nested sub-query inside of a having clause Row groupings can be filtered using the HAVING clause. It…

Q: 7. For each project, display project name, project platform, project cost and total number of…

A: In sql, we use SELECT statement to display the table details according to the requirement. We will…

Q: Write a SELECT statement that uses a correlated subquery to return one row per customer,…

A: SYNTAX - SELECT cust.first_name, cust.last_name, o.order_id, o.order_date, o.total_quantityFROM…

Q: Display the manager number and the salary of the lowest paid employee for that manager. Exclude…

A: We will write SQL query to solve the given problem.

Q: please use the picture below to answer the following question Display employee number, employee…

A: SELECT EmployeeID, Emp_LName, HireDate FROM Employee e JOIN Position pWHERE e.Emp_LName like '%e%'…

Q: Create the following tables and insert some values. STUDENT (STDNO, SNAME, DEPTNO#) DEP (DEPTNO,…

A: Below are the required queries:

Q: Select lastname, firstname from employeetab,Manager where employeetab.manager_id=Manager.managerid…

A: Answer: We need to explain the SQL code and how it works. so we will see in the more details with…

Q: group

A: SQL stands for structured query language and has a number of clauses to run queries. Major and…

Q: When should a subquery be nested inside of a HAVING clause?

A: Introduction: Nesting of a subquery inside a HAVING clauseIt is possible to filter groups of rows…

Q: Which operator should you employ in order to locate NULL values?

A: IS NULL operator is used to locate NULL values

Q: You are given the following data tables: Employees(Employeel D, LastName, FirstName, BirthDate,…

A: In this question, we have been given the data tables and we have to write a query where to find all…

Q: 2. Can you describe the below operation with example? (Give some data in section table and then…

A: The query is given. Let's assume the sample table

Q: Display the PID and average prices from the PRODUCTS table which price is less than the average…

A: Here we need to perform group by operation in the main query and use Having clause to select only…

Q: For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name,…

A: Hi there, Please find your solution below, I hope you would find my solution useful and helpful.…

Q: a) Find department_id for departments that do not contain the job id ST_CLERK a) lists the employee…

A: In this question we have to provide the SQL code for the following queries. Let's query and hope…

Q: Select FirstName,LastName,department,project_name,hours from employeetab,Project where…

A: This SQL code aims to select certain columns from two tables, employeetab and Project, join them…

Q: 9. Find the total amount of tax paid by resident of NJ Hint: The tax cost stored in tax_amount…

A: Inner join is used to join two tables. Tax_amount column is given , to find sum value of a column.…

Q: Task 9: Use a subquery to find the sales rep ID, first name, and last name of each sales rep who…

A: According to the question here we will choose in statement while writing the subquery. The subquery…

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

Q: Display the last name, salary, and commission for all employees who earn commissions. Sort data in…

A: In the above question, needs to find out only those employee's last name, salary, and commission who…

Q: Task 9: Use a subquery to find the sales rep ID, first name, and last name of each sales rep who…

A: 9. SELECT rep.rep_ID,rep.last_name,rep.first_name FROM rep WHERE rep.rep_ID IN (SELECT rep_ID FROM…

Q: 7. List all customers who were referred to the bookstore by another customer. List each customer’s…

A: The answer to the question is given below:

Q: ServiceCategory CategoryNum CategoryDescription 1 Plumbing 2 Heating/Air Conditioning 3 Painting 4…

A: The query to List the location number and unit number for every condo whose square footage is equal…

Q: Using the AND or OR statement, filter the employee table for employees who live in the city…

A: The statement given, We have to use AND or OR operator to get the employees who live in the city…

Q: I. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name…

A: Given: To write the SQL query.

Q: For every completed or 'open service request for janitorial work', list the condo id, description,…

A: The querry has given

Q: A customers table has the following columns: ID, NAME, AGE, ADDRESS and SALARY. Write an SQL code…

A: select ID,NAME, SALARY from CUSTOMERS where SALARY>2000; //The above SQL query will fetch all ID…

Q: 1. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name…

A: Given: Structure of a table employee is given having attributes First_Name, Last_Name, SSN_Number.…

Q: Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To…

A: Sure, I can help you with that. The StayWell marketing team wants to send small gifts to all…

Q: Find the ID, first name, and last name of each customer whose first name begins with the letter S.

A: The question has been answered in step2:

Q: Determine which categories are covered by the existing book stock. There should only be one listing…

A: A trader's book contains a record of all of the positions that they have taken. The entire number of…

Q: Which SQL statement will return the same results as the following SQL statement? SELECT * FROM…

A: Answer: Option 2,3, and 4 are having the where conditions will give the different results

Q: Select clause: Display the columns stated in the problem statement From clause: AUTHOR table…

A: SQL is a structured query language, that's is used to extract and manipulate the data from the…

Q: Determine which types of books are currently available in the current inventory. Each category…

A: Real-world examples can make inventory models easier to understand. The following examples…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Question

Based on the ERD below, display the first name, last name and employee initial of anyone whose first name starts with “A”. (Hint: You will use a “Like” phrase.)