SQL Queries for Practice - Part 2 - SQL Queries based on Aggregate Function

Описание: Aggregate functions based SQL Queries , SQL queries for practice , sql queries example , sql queries based on aggregate function for practice

Following are the queries which we discussed in this video:-

1. Select the count of all female candidates
2. Select the sum of salary of all female employee
3. Select the maximum age of employee
4. Select the maximum age of male employee
5. Select the sum of salary of all employees having age above 25
6. count the total employee of company
7. select the count of employee whose age is between 25 to 30
8. select the minimum age of employee
9. select the count of employee whose email id is gmail
10. select the count of employee whose salary is above 30000

Check our following link :-

Tech Altum Tutorial :- https://tutorial.techaltum.com/
Tech Altum Training Website :- https://www.techaltum.com/
Facebook Link :-   / thetechaltum  
Twitter Link :-   / techaltum  
Isha Malhotra :-   / isha.malhotra3388