Slip 16 - D) Consider the above tables and execute the following queries: 1. Display employee details who have invested more than 100000. 2. Display employee wise total investment amount. 3. Display the employee names who invest on date 2nd Jan 2013. 4. Display employee whose investment are more than 3. 5. Find average investment of employees of Pune.
Solution:
0 Comments