Issues: TriptiGitRepo/SQL_Interview_Questions_and_Solution
Issues list
SQL Query to display the highest lowest and average salary for each job role.
enhancement
New feature or request
#67
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to list all employees who do not have a bonus
enhancement
New feature or request
#66
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to display employees grouped by their salary range
enhancement
New feature or request
#65
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to find all employees who are older than 30 years
enhancement
New feature or request
#64
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to display the hire date and day of the week for each employee
enhancement
New feature or request
#63
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to retrieve the year to date sales for each customer
enhancement
New feature or request
#62
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to find all employees whose e-mail contains the domain @gmail.com
enhancement
New feature or request
#61
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to calculate the percentage of employees in each department
enhancement
New feature or request
#60
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to display employees’ group by their age bracket for example 21-30,31 - 40 etc
enhancement
New feature or request
#59
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to find employees whose salary is in the top 10%
enhancement
New feature or request
#58
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to display employee name add hire date in the format name- mm/dd/yyyy
enhancement
New feature or request
#57
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to list all managers who have more than five subordinates
enhancement
New feature or request
#56
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to find all employees who own more than the average salary of their department
enhancement
New feature or request
#55
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to list all employees with more than five years of experience in each department.
enhancement
New feature or request
#54
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to find the top three highest paid employees in each department
enhancement
New feature or request
#53
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to list all employees working under the same manager.
enhancement
New feature or request
#52
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to delete employees who have been in the company for more than 15 years
enhancement
New feature or request
#51
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to find employees with the same first name
enhancement
New feature or request
#50
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to get employees who belong to departments with less than three employees.
enhancement
New feature or request
#49
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to find employees who salary is higher than their manager's salary
enhancement
New feature or request
#48
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to retrieve employee name and salary in a single string
enhancement
New feature or request
#47
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to count the number of employees whose name start and end with the same letter
enhancement
New feature or request
#46
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to find employees who joined the company in the same month and year as their manager
enhancement
New feature or request
#45
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to display department wise total and average salary
enhancement
New feature or request
#44
opened Nov 26, 2024 by
TriptiGitRepo
SQL Query to list all employees hired in the last six months
enhancement
New feature or request
#43
opened Nov 26, 2024 by
TriptiGitRepo
ProTip!
Type g p on any issue or pull request to go back to the pull request listing page.