1. Which course has maximum fees.
2. List out the courses that is taken in Chennai.
3. List out the courses that is taken online training from Bangalore.
4. What is the fees for online oracle dba training in chennai.
5. List out the course name from c001 to c006
6. Print the total fees that which is taken for all ONLINE training course.
7. Print the Characters starting with 2 , 5 from training type.
Eg. for ONLINE -> NLIN, for CLASSROOOM -> LASS
8. Print the fees total with respect to location
eg .
CHENNAI 135000
MUMBAI 55000
BANGALORE 84000
9. Print out the Location that has 2 ‘A’s.
eg. BANGALORE
10. Print out the courses that starts with ‘O’
11. Print out the courses that has “_”.
12. Replace ‘ONLINE’ in TRAINING_TYPE as ‘ONLION’
13. Which course has second highest duration.
14. What are the course names that has location ends with ‘I’
15. Print the courses for which fees is between 10000 and 20000
16. Which course has maximum character and its count.
eg. ORACLE_DEVELOPER 15
17. Remove ‘C’ from COURSE_ID and find the highest number from it.
Eg. 19.
18. Print the record that has C012 two times
19. Find the Highest average of Classroom training Fees respective to location.
20. Find the sum of salaray with respective to training_type and location.