mysql> SELECT * FROM Employee;
+----+-------------------+-----+--------+----------------+----------+--------------+
| id | name | age | salary | designation | city | joining_year |
+----+-------------------+-----+--------+----------------+----------+--------------+
| 1 | Koushal Admuthe | 19 | 4000 | web developer | sangli | 1980 |
| 2 | Aryan Mungare | 19 | 35000 | AIML Developer | Kolhapur | 1981 |
| 3 | Aditya Borhade | 20 | 10000 | AIML Developer | Pune | 1980 |
| 4 | Drumil Adbhai | 21 | 20000 | Manager | Mumbai | 1981 |
| 5 | Arpita Golwad | 21 | 15000 | Co-Manager | Mumbai | 1982 |
| 6 | Sangram Patil | 20 | 15000 | Co-Manager | Mumbai | 1982 |
| 7 | Arya Chavan | 20 | 4000 | web developer | Nashik | 1981 |
| 8 | Harshwardhan Auti | 21 | 20000 | janitor | Pune | 1981 |
| 9 | Aditya Khandekar | 21 | 10000 | AIML Developer | Pune | 1979 |
| 10 | Akanksha Algunde | 21 | 30000 | Senior Manager | Pune | 1979 |
+----+-------------------+-----+--------+----------------+----------+--------------+
10 rows in set (0.00 sec)
mysql> SELECT DISTINCT designation FROM Employee;
+----------------+
| designation |
+----------------+
| web developer |
| AIML Developer |
| Manager |
| Co-Manager |
| janitor |
| Senior Manager |
+----------------+
6 rows in set (0.00 sec)
mysql> SELECT * FROM Employee ORDER BY salary ASC;
+----+-------------------+-----+--------+----------------+----------+--------------+
| id | name | age | salary | designation | city | joining_year |
+----+-------------------+-----+--------+----------------+----------+--------------+
| 1 | Koushal Admuthe | 19 | 4000 | web developer | sangli | 1980 |
| 7 | Arya Chavan | 20 | 4000 | web developer | Nashik | 1981 |
| 3 | Aditya Borhade | 20 | 10000 | AIML Developer | Pune | 1980 |
| 9 | Aditya Khandekar | 21 | 10000 | AIML Developer | Pune | 1979 |
| 5 | Arpita Golwad | 21 | 15000 | Co-Manager | Mumbai | 1982 |
| 6 | Sangram Patil | 20 | 15000 | Co-Manager | Mumbai | 1982 |
| 4 | Drumil Adbhai | 21 | 20000 | Manager | Mumbai | 1981 |
| 8 | Harshwardhan Auti | 21 | 20000 | janitor | Pune | 1981 |
| 10 | Akanksha Algunde | 21 | 30000 | Senior Manager | Pune | 1979 |
+----+-------------------+-----+--------+----------------+----------+--------------+
9 rows in set (0.00 sec)
mysql> SELECT AVG(salary) AS average_salary FROM Employee;
+----------------+
| average_salary |
+----------------+
| 16300.0 |
+----------------+
1 row in set (0.00 sec)
mysql> SELECT MIN(salary) AS min_salary, MAX(salary) AS max_salary FROM Employee;
+------------+------------+
| min_salary | max_salary |
+------------+------------+
| 4000 | 35000 |
+------------+------------+
1 row in set (0.00 sec)
mysql> SELECT * FROM Employee WHERE name LIKE 'P%';
Empty set (0.00 sec)
mysql> SELECT name FROM Employee WHERE name LIKE '%a';
Empty set (0.00 sec)
mysql> SELECT DISTINCT salary FROM Employee ORDER BY salary DESC LIMIT 1 OFFSET 1;
+--------+
| salary |
+--------+
| 30000 |
+--------+
1 row in set (0.00 sec)
mysql> SELECT * FROM Employee WHERE salary >= 10000 ORDER BY designation;
+----+-------------------+-----+--------+----------------+----------+--------------+
| id | name | age | salary | designation | city | joining_year |
+----+-------------------+-----+--------+----------------+----------+--------------+
| 2 | Aryan Mungare | 19 | 35000 | AIML Developer | Kolhapur | 1981 |
| 3 | Aditya Borhade | 20 | 10000 | AIML Developer | Pune | 1980 |
| 9 | Aditya Khandekar | 21 | 10000 | AIML Developer | Pune | 1979 |
| 5 | Arpita Golwad | 21 | 15000 | Co-Manager | Mumbai | 1982 |
| 6 | Sangram Patil | 20 | 15000 | Co-Manager | Mumbai | 1982 |
| 8 | Harshwardhan Auti | 21 | 20000 | janitor | Pune | 1981 |
| 4 | Drumil Adbhai | 21 | 20000 | Manager | Mumbai | 1981 |
| 10 | Akanksha Algunde | 21 | 30000 | Senior Manager | Pune | 1979 |
+----+-------------------+-----+--------+----------------+----------+--------------+
8 rows in set (0.00 sec)
mysql> SELECT designation, name, salary
-> FROM Employee e
-> WHERE salary = (
-> SELECT MAX(salary)
-> FROM Employee
-> WHERE designation = e.designation
-> );
+----------------+-------------------+--------+
| designation | name | salary |
+----------------+-------------------+--------+
| web developer | Koushal Admuthe | 4000 |
| web developer | Arya Chavan | 4000 |
| AIML Developer | Aryan Mungare | 35000 |
| AIML Developer | Aditya Borhade | 10000 |
| AIML Developer | Aditya Khandekar | 10000 |
| Co-Manager | Arpita Golwad | 15000 |
| Co-Manager | Sangram Patil | 15000 |
| Manager | Drumil Adbhai | 20000 |
| janitor | Harshwardhan Auti | 20000 |
| Senior Manager | Akanksha Algunde | 30000 |
+----------------+-------------------+--------+
10 rows in set (0.00 sec)
mysql> UPDATE Employee SET salary = salary * 1.10;
Query OK, 10 rows affected (0.01 sec)
mysql> SELECT name AS Employee_Name, salary AS Monthly_Salary FROM Employee;
+-------------------+----------------+
| Employee_Name | Monthly_Salary |
+-------------------+----------------+
| Koushal Admuthe | 4400 |
| Aryan Mungare | 38500 |
| Aditya Borhade | 11000 |
| Drumil Adbhai | 22000 |
| Arpita Golwad | 16500 |
| Sangram Patil | 16500 |
| Arya Chavan | 4400 |
| Harshwardhan Auti | 22000 |
| Aditya Khandekar | 11000 |
| Akanksha Algunde | 33000 |
+-------------------+----------------+
10 rows in set (0.00 sec)
