Mile To Tum Kabhi Nahi Meri Hasrat Kyun Bhadkai Bewajah Ke Tum Bina Jiye Agar Hua Kaise Naa Yeh Jeena Raigan? Dariya Mere Dil Ka Yeh Behta Na Dukhi Dil Ki Sada Kuch Yeh Kehta Na Iski Khamoshi Ki Tu Wajah Hai Na Dil Se Tang Aaya Yehhi Saza Hai Na Ulfaton Mein Nahi Koi Paimana Mere Apnon Ka Mujh Se Yeh Kehna Tha Surmai Teri Aankhon Mein Beh Jaana Kya Pata Tere Gham Mein Hi Rehna Tha Kyun Yun Sehte Sehte Dil Ko Gham Kha Chuka Meri Jaan Kyun Yun Rehte Rehte Dikhayi Na Koi Disha Kyun Yun Sehte Sehte Dil Ko Gham Kha Chuka Meri Jaan Kyun Yun Rehte Rehte Dikhayi Na Koi Disha Jo Tu Nahi Toh Aisa Main Chehra Ke Jiski Khoobsurti Maand Padti Ho Aisa Main Dariya Jo Behna Na Chahe Jo Tu Nahi Toh Aisa Main Chehra Ke Jiski Khoobsurti Maand Padti Ho Aisa Main Dariya Jo Behna Na Chahe Dariya Mere Dil Ka Yeh Behta Na Dukhi Dil Ki Sada Kuch Yeh Kehta Na Iski Khamoshi Ki Tu Wajah Hai Na Dil Se Tang Aaya Yehhi Saza Hai Na Ulfaton Mein Nahi Koi Paimana Mere Apnon Ka Mujh Se Yeh Kehna Tha Surmai Teri Aankhon Mein Beh Jaana Kya Pata Tere Gham Mein Hi Rehna Tha Aisa Main Dariya Jo Behna Na Chahe
Sunday, May 11, 2025
Jo Tu Nahi Toh Aisa Main Chehra
Subscribe to:
Post Comments (Atom)
a)select emp.emp_name from emp, works where emp.emp_id = works.emp_id and works.company_name = 'SBI';
ReplyDelete+----------+
| emp_name |
+----------+
| Adarsh |
| Bonny |
+----------+
b)select emp.emp_name from emp, works, company where emp.emp_id = works.emp_id and works.company_name = company.company_name and emp.city = company.city;
+----------+
| emp_name |
+----------+
| Adarsh |
| Bonny |
| George |
+----------+
c)select emp.emp_name, manages.manager_name from emp, manages, emp as manager where emp.emp_id = manages.emp_id and manages.manager_id = manager.emp_id and emp.city = manager.city and emp.Street_No = manager.Street_No;
+----------+
| emp_name | manager_name |
+----------+--------------+
| Adarsh | Bonny |
+----------+--------------+
d)select emp.emp_name from emp, works where emp.emp_id = works.emp_id and works.salary > ( select AVG(salary) from works as w2 where w2.company_name = works.company_name );
| emp_name |
+----------+
| Bonny |
| Hayes |
| Johnson |
| Lavanya |
e)select company_name, sum(salary) from works group by company_name order by sum(salary) ASC LIMIT 1;
+--------------+-------------+
| company_name | sum(salary) |
+--------------+-------------+
| SIB | 39000 |
+--------------+-------------+
f)update works set salary = salary * 1.10 where emp_id in ( select manager_id from manages, works where manages.manager_id = works.emp_id and works.company_name = 'SBI' );
g)select company_name, count(emp_id) from works group by company_name order by count(emp_id) desc limit 1;
+--------------+---------------+
| company_name | count(emp_id) |
+--------------+---------------+
| SBT | 3 |
h)select company_name from works group by company_name having avg(salary) > ( select avg(salary) from works where company_name = 'Indian Bank');
+--------------+
| company_name |
+--------------+
| FEDERAL |
| SBI |
| SBT |
+--------------+
i)select emp.emp_name, works.salary from emp, works where emp.emp_id = works.emp_id and works.salary > all ( select salary from works where company_name = 'Indian Bank' );
+-----------+--------+
| emp_name | salary |
+-----------+--------+
| Adarsh | 71000 |
| Bonny | 90000 |
| Catherine | 40000 |
| Lavanya | 250000 |
| Niharika | 40000 |
+-----------+--------+