pls help me SQL Instructions: Answers ALL the questions. This test contributes 5% to your coursework. Use the following Table to write the queries. Emp Infor Table EmpID EmpFname EmpLname Department Salary 1 Mohd Ali HR 2000 2 Azizah Suliman Admin 3 Chen Kang Kulkarni 4 Ananthi 5 Manjit Sidhu Address Kuantan 3500 Ipoh 5000 Kuala Lumpur Georgetown Kangar Account HR 1800 Admin 8000 DOB Gender 01/12/1977 M 02/05/1975 01/01/1984 02/05/1995 F 03/07/1998 M 1. Write the query to display all the records in the Emp_Infor table. F M 2. Write a query to display the number of employees working in the department 'HR'.
pls help me SQL Instructions: Answers ALL the questions. This test contributes 5% to your coursework. Use the following Table to write the queries. Emp Infor Table EmpID EmpFname EmpLname Department Salary 1 Mohd Ali HR 2000 2 Azizah Suliman Admin 3 Chen Kang Kulkarni 4 Ananthi 5 Manjit Sidhu Address Kuantan 3500 Ipoh 5000 Kuala Lumpur Georgetown Kangar Account HR 1800 Admin 8000 DOB Gender 01/12/1977 M 02/05/1975 01/01/1984 02/05/1995 F 03/07/1998 M 1. Write the query to display all the records in the Emp_Infor table. F M 2. Write a query to display the number of employees working in the department 'HR'.
Chapter11: Group Functions
Section: Chapter Questions
Problem 18MC
Related questions
Question
![pls help me SQL
Instructions:
Answers ALL the questions. This test contributes 5% to your coursework.
Use the following Table to write the queries.
Emp_Infor Table
EmpID EmpFname EmpLname Department Salary
1
Mohd
Ali
HR
2000
Admin
Account
2
3
4
5
Azizah
Chen
Ananthi
Manjit
Suliman
Kang
Kulkarni
Sidhu
HR
Admin
Address
Kuantan
Ipoh
1800
8000
DOB
01/12/1977
02/05/1975
3500
5000 Kuala Lumpur 01/01/1984
Georgetown 02/05/1995
Kangar 03/07/1998
1. Write the query to display all the records in the Emp_Infor table.
Gender
MFMFM
2. Write a query to display the number of employees working in the department
'HR'.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fa9b79a46-de9c-41f4-a0e3-777d8e119f43%2Fb9b3006e-4429-4511-a00d-b040f888f1a7%2Fmjwvlxp_processed.png&w=3840&q=75)
Transcribed Image Text:pls help me SQL
Instructions:
Answers ALL the questions. This test contributes 5% to your coursework.
Use the following Table to write the queries.
Emp_Infor Table
EmpID EmpFname EmpLname Department Salary
1
Mohd
Ali
HR
2000
Admin
Account
2
3
4
5
Azizah
Chen
Ananthi
Manjit
Suliman
Kang
Kulkarni
Sidhu
HR
Admin
Address
Kuantan
Ipoh
1800
8000
DOB
01/12/1977
02/05/1975
3500
5000 Kuala Lumpur 01/01/1984
Georgetown 02/05/1995
Kangar 03/07/1998
1. Write the query to display all the records in the Emp_Infor table.
Gender
MFMFM
2. Write a query to display the number of employees working in the department
'HR'.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr