Write SQL Queries for following Employee table : EMPLOYEE_ID| Name EMAIL HIRE_DATE SALARY DEPARTMENT Juniad@abc.com 2010-06-18 2011-04-16 Hassan Hassan@abc.com 2010-03-08 Fahad@abc.com |2013-01-28 | 2012-01-28 Juniad 110000.00 | CS 100000.00 Sales 88000.00 101 102 Irfan Irfan@abc.com 103 Marketing 90000.00 Fahad Husnain Hus@abc.com 104 Sales 105 55000.00 ES 1. Write a query to display sales and marketing department data. 2. Write a query to get the names, salary, PF of all the employees (PF is calculated as 15% of salary). 3. Write a query to get the total salaries payable to employees.

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: Examine this product table's column definitions: pid number primary key pname varchar2(50) You must…

A: Given:

Q: Write sql query to create given table.

A: Given, Table:

Q: Using the the Employees table below write an SQL query which displays Last Name, First Name and how…

A: As per the table above, we have the ID, LastName, FirstName, Birthdate, Payrate, and HoursWorked…

Q: question 9 please use the picture below to answer the following question Write a SQL statement to…

A: Query: The below query is used to create a table named “new_Invoice” which is exactly the same as…

Q: Write SQL Queries for following Employee table : EMPLOYEE_ID Name EMAIL HIRE DATE SALARY DEPARTMENT…

A: The name of the given table is Employee. It has six columns named EMPLOYEE_ID, Name, EMAIL,…

Q: Create the following table in your database with the following schema: Table: Sales | Column Name |…

A: Create a table Sales: CREATE TABLE Sales (    sale_id int,   product_name varchar(255),…

Q: 1. Use the following table to answer the questions below. Table name: Products Column Role Data Type…

A: We have to extract year from the Date filed and then the year has to be 2021  Now, we have to count…

Q: The HR department needs a report to display employee information as shown from the job_history…

A: SOLUTION- With using DATEDIFF - Below is the SQL query that you could use to generate the report:…

Q: 5. Write a query to get the total salaries payable to employees. 6. Write a query to get the…

A: Sorry, we are supposed to answer only three subparts of question ad kindly resubmit the remaining…

Q: Instructions: Write the suitable SQL statement to answer the following questions based on the…

A: Answer: SELECT DEP_NO, COUNT(*) FROM Employee GROUP BY DEP_NO;

Q: Write the SQL code that counts the number of assignments ordered for each project. Call this…

A: We have four tables namely: JOB PROJECT EMPLOYEE ASSIGNMENT We wish to write a query that counts…

Q: Based on the ERD below, write the SQL statement to display the average hourly job charge for a job.

A: Query to display the average hourly job charge for a job. To get average hourly job charge for all…

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: 10. Create a query to for this report: Supplier M MacLaren's Irish Pub MacLaren's Irish Pub Central…

A: Answer: Let's say table name is SUPPLIER_DETAILS: FOR MYSQL: SELECT SUPPLIER_M "Supplier Name", PO_N…

Q: SQL FOR THERES TABLES

A: To write SQL query  for the given table

Q: - Copy the name, salary, and commission of each employee hired before 1980 into TEMP table - Copy…

A: INSERT INTO query is used to copy the sql data from one table to another table.WHERE is SQL clause…

Q: Parking_Number Car_Model Course Marketing lent_ID 2 Toyota 4 BMW Business IT Оpel Ford Hyundai…

A: Given that using the join statement select records that matching in both tables limited to…

Q: Input: SalesPerson table: ----+- +------ I sales_id | name | salary | commission_rate | hire_date…

A: Select name from salesPerson join orders on salesperson.sales_id=orders.sales_id where (select…

Q: database with Howing BUIMOTTO Table: Employees | Column Name 1 Туре I id | int | varchar I I name…

A: The SQL queried is given below.

Q: Display customer number, customer name, and location for customers whose Customer_name starts with…

A: The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. ORDER BY…

Q: Write an appropriate SQL query to display all the STUDENT_SURNAMES and STUDENT_NAMES, as well as the…

A: The table name is Student Module. Student Surnames and Names should be displayed using the query.…

Q: List the names of places from which the company sells in the form of a query in Microsoft access.…

A: The objective of the question is to create a query in Microsoft Access that lists the names of…

Q: Write SQL query. Table:- Employees Columns:- ID,NAME,SALARY, DEPT_NAME Find department name where…

A: Given:-Write SQL query.Table:- EmployeesColumns:- ID,NAME,SALARY, DEPT_NAMFind department name where…

Q: Create a SQL query to generate the required report containing the combined customer name, employee…

A: A Database Management System is a software application or system that enables the creation,…

Q: Write the SQL code required to list the first name and last name of all customers whose middle…

A: Writing the SQL code required to list the first name and last name of all customers whose middle…

Q: For each department with more than one member of employee, find the sum of reward amounts for each…

A: The question is solved in step2

Q: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

A: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

Q: DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID 10 Administration 200 1700 Marketing 201 1800…

A: According to the asked question, the solution is given below with a proper explanation.

Q: Given the table, EMPLOYEES below with the following rows, how many rows are generated by the SQL…

A: c. 1

Q: Write an appropriate SQL query to determine which student is registered for the most credits (total…

A: In this question we have to write a sql query for given statement and table. Let's complete the sql…

Q: which is more accurate? and are they even right?

A: The question has been answered in step2

Q: Write a sql query to create the given table.

A:

Q: Using the EMP_2 table, write the SQL code that will add the attributes EMP_PCT and PROJ_NUM to…

A: The question is asking for an SQL command that will add two new columns to an existing table named…