Final_project_SQL_Queries.

Create a Table on MySQL or PostgreSQL database -,

write query ::: I) “select count(*) from users”, Write an optimized query against this.

ii) View all users and employers who get the maximum salary from each group.

iii) If you want to delete everything of Users, write a query.

iv) Get the second highest salary from the Users table and which users get them.

v) How to get distinct records from the Names from the users table without using distinct keywords.

vi) How to find the count of duplicate rows from a table?

vii) Remove duplicates from users but keep one.