1.Display the details of council inspector(s) who has/have never performed any inspection. 2.For each of the suburbs, display the number of successful applications. 3.For each of the applications...

1.Display the details of council inspector(s) who has/have never performed any inspection.

2.For each of the suburbs, display the number of successful applications.

3.For each of the applications display the application number, details of owner and total charges.

4.Display the lowest, the highest and average number of applications in the advertisements.

5.Which application(s) did receive the highest number of objections? Display the details of those application(s) and their respective applicant(s) in descending order of their name.

6.Display the details of the applicant(s) whose name contains the word “build”.  Show the results in ascending order of their name.