Perform following queries using SQL: 

(i) To find the total rent earned during certain time interval (input to be given by the user) for          a   particular aptID.
(ii) To display all the aptIDs if the street ID and City are given. 
(iii) To display the list of all the renters who have more than one apt.
(iv) To display the list of all aptIDs whose rent is equal to or more than Rs.15,000/- per month          in  a particular street with apt size more than 850sq feet. 
(v) To display all the details of the apartment which were bought before year 2000 in a                      particular city  and street. 

Write shell programs for the following:                                                                           (15 Marks) 

(a) To find second largest number among the 5 numbers given. 

(b) To find sum of all the alternate digits in a given 7 digit number. 

(c) To count number of vowels in a given string. 

(d) To take 2 strings as input, concatenate them and display the length of the resultant string. 

(e) To display the reverse of a given number. 

Write and execute the following UNIX commands: 
(a) To change the password.
(b) To search files in the current directory/subdirectory for lines that match a particular string pattern        given as input.
 (c) To print the first 5 lines of a file.
(d) To print the number of processes run by a particular user.
(e) To kill a process that is running at the background.
(f) To display the count of no. of blank spaces in a given file.
(g) To sort alphabetically, a list of numbers stored in a data file in an ascending order.
(h) To convert the upper case letters to corresponding lower case letters in a text file.
(i) To count the number of users currently logged on.
(j) To display the calendar for a given month and year.