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: 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: 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: - 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: 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: Write an appropriate SQL query to delete the following record from the STUDENTS table:…

A: Answer: We need to write the query for the delete the record from the table so we will see in the…

Q: EMPLOYEE TABLE EMPLOYEE_ID FIRST_NAME SURNAME CONTACT NUMBER emp101 0877277521 emp102 emp103 emp104…

A: The queries for creating and inserting data to all tables are given below along with final OUTPUT…

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: 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: 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…

Q: Hi! cany you help me create a table using SQL based from this picture

A: To create a table you need to analyse the column name and data type from table structure.  Syntax:-…

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

A: Question. Write a sql query to create the given table. Answer. To create a table in SQL we'll use…

Q: Please write the MySQL query for the following task: Find the first_name, last_name, employee_id,…

A: we can use the following MySQL query:

Q: Table : PURCHASE_ORDER ORDER_NO AMOUNT ORDER DATE CUSTOMER_ID SALESMAN ID DELIVERY_ DATE 1001 300…

A: b) SELECT * FROM PURCHASE_ORDER INNER JOIN PURCHASE_DETAILS ON PURCHASE_ORDER.ORDER_NO =…

Q: With SQL code, find the name of each employee with a manager along with their manager's name (use…

A: For finding this query  we will use the join clause.

Q: Please convert following figure into a relational schema. In each table, the primary key and foreign…

A: Here the entity BankBranch is a weak entity and therefore we need to include primary key of Bank as…

Q: What values are returned while the given query is executed? SELECT 2* (Balance - Payment) FROM…

A: The query selects the result of the expression 2*(Balance - Payment) for each row in the "Customer"…

Q: Refer to the Compensation table below. ID Name Salary Bonus 2538 Lisa Ellison 115000 NULL 5348 Sam…

A: In SQL, the MAX() function is an aggregate function used to find the maximum value of a numeric…

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

A: Given: Write a sql query to create the given table.

Q: Write query to create given table 'MAIN'

A: Given, Table:

Q: I need help with this SQL query:  Write a MySQL statement to create a table named jobs including…

A: Hello student. Warm welcome from my side. Hope you are doing great. I will try my best to answer…

Q: Write an SQL statement that combine the courses and teachers tables to query the ames of all courses…

A: Apply Inner Join on both Courses and Teachers table based on the id of teacher and teacherid in…

Q: e DEPARTMENTS table has the following data: DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID 10…

A: Here all the tuple of column Manger_id will be selected.  Order by clause will arrange the ids in…

Q: Branch Table Column Name BR_ID Data Type NUMBER FK Description Each Branch will have a Unique Size…

A: Note: 1. we had make sure that foreign key at child table data type matches with parent table data…

Q: Write SQL CODE to make changes as shown in the following table: [5] Parking

A: I have provided SQL code in step2