Answers ALL the questions. 1Use the following Table to write the queries.Emp Infor TableEmpID EmpFrame Emplasme Department Salary AddressAkHR2000SalimAdminKang4AriralChesAsahiMajitAcco1000121800Admin 1000Kuala LumpGeorgKamperDOB01/12/1977 M02/05/1975 FGender08 01/1954 M0205/1995 705/07/1998 M1. Write the query to display all the records in the Emp_Infortable.2. Write a query to display the number of employees working in the department"HR. "3. Write a query to display the EmpFname from the EMP Infor table and use theALIAS name as Staff Name.

Here is the complete solution of the above problem. See below steps.

Answers ALL the questions. 1 Use the following Table to write the queries. Emp Infor Table EmpID EmpFrame Emplasme Department Salary 1 A HR 2000 4 Ariral Ches Asu Majit K Kalami Sidhu M 1000 12 1800 Admin 1000 DOB Gender 01/12/1977 M 02/05/1975 F Kuala Lump 08 01/1954 M C0005/1995 7 Kangar 05/07/1998 M Address Ka 1. Write the query to display all the records in the Emp_Infortable. X 2. Write a query to display the number of employees working in the department "IR". 3. Write a query to display the EmpFname from the EMP Infor table and use the ALIAS name as StaffName.

Answers ALL the questions. 1 Use the following Table to write the queries. Emp Infor Table EmpID EmpFrame Emplasme Department Salary 1 A HR 2000 4 Ariral Ches Asu Majit K Kalami Sidhu M 1000 12 1800 Admin 1000 DOB Gender 01/12/1977 M 02/05/1975 F Kuala Lump 08 01/1954 M C0005/1995 7 Kangar 05/07/1998 M Address Ka 1. Write the query to display all the records in the Emp_Infortable. X 2. Write a query to display the number of employees working in the department "IR". 3. Write a query to display the EmpFname from the EMP Infor table and use the ALIAS name as StaffName.

Database System Concepts

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

See similar textbooks

Similar questions

Write an SQL query to extract the answer directly.
Please answer questions
Using SQL find the number of employees from the table:
Make the following tables database:
Product Order PID Description Quantity 300 Price Vendor OID Date 2012/5/23 2 CID Unique traders AT Cosmetics General traders Unique traders General traders Foodie Shop Shampoo 50 1 1 2 Soap 140 230 40 30 2012/5/24 3 Detergent 4 2016/4/23 4 Milk 14 33 3 2016/2/12 2016/1/10 4 Lemon Max 10 20 6 1 6. Chocolate 34 34 Invoice Customer OrderNo 1 ProductID Quantity CustomerID Name city 1 1 Ali Rawalpindi 1 3 1 Ahmad Islamabad 4 2 1 Umer Chakwal 2 6. 3 Каrim Islamabad 2 3 1 Shafig Islamabad 3 2 6. Waleed Rawat 4 Afzal Islamabad 4 3 4 1 Bilal Rawalpindi 4 4 Write SQL queries for the following statements (Use only Cartesian product and join) 1. Showname of customerand orderno who have placed any order and belong to "Islamabad". 2. Showname of customer and product description who placed order before 2016/2/23. 3. Show data of those customer who place two or more than two order in same day. 4. Showdata of those product that are purchased by those customer who neither belong 5. To"Rawat"nor…
Please provide answer and explanation as well