Question

USE SQL PROGRAMMING!!!

Give an example.

In this problems there are 3 rankings: 1 (best ranking), 2(second to best), 3(worse)

Write a query that lists all companies that have an employee ranking between 1-3 stars for 2021. The query should provide the company name as company_name, the ranking of the best employee for 2021 as employee_ranking, and the number of employees that had a ranking between 1-3 for 2021 as num_ranking. More than one employee can rank the same.

Answer 1

To list all companies with employee rankings between 1-3 stars for 2021, we can use SQL programming and the SELECT statement. We will need to join two tables: the company table and the employee table. The company table will provide the company name, while the employee table will provide the employee rankings. We can use the WHERE clause to filter for rankings between 1-3 stars for 2021. Finally, we can use the COUNT function to obtain the number of employees with rankings between 1-3 for each company.

Step-by-step explanation:

To list all companies with employee rankings between 1-3 stars for 2021, we can use SQL programming and the SELECT statement. We will need to join two tables: the company table and the employee table. The company table will provide the company name, while the employee table will provide the employee rankings.

We can use the WHERE clause to filter for rankings between 1-3 stars for 2021. Finally, we can use the COUNT function to obtain the number of employees with rankings between 1-3 for each company.

The SQL query would be:

SELECT c.company_name AS company_name, e.employee_ranking AS employee_ranking, COUNT(e.employee_ranking) AS num_rankingFROM company cJOIN employee e ON c.company_id = e.company_idWHERE e.employee_ranking BETWEEN 1 AND 3GROUP BY c.company_name, e.employee_ranking

This query will return the company name, the ranking of the best employee for 2021, and the number of employees with rankings between 1-3 for each company.