Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii),
which are based on the tables.
                                Table: CUSTOMER

                                         Table: TRANSACTION

(i) To display details of all transactions of TYPE Credit from table TRANSACTION.
(ii) To display the CNO and AMOUNT of all Transactions done in the month of September 2017 from table TRANSACTION.
(iii) To display the last date of transaction (DOT) from the table TRANSACTION for the customer having CNO as 103.
(iv) To display all CNO, CNAME and DOT (date of transaction) of those CUSTOMERS from tables CUSTOMER and TRANSACTION who have done transactions more than or equal to 2000.
(v) SELECT COUNT(*), AVG (AMOUNT) FROM TRANSACTION WHERE DOT> = '2017-06-01';
(vi) SELECT CNO, COUNT("), MAX (AMOUNT) FROM TRANSACTION GROUP BY CNO HAVING COUNT (")> 1;
(vii) SELECT CNO, CNAME FROM CUSTOMER WHERE ADDRESS NOT IN ('DELHI' 'BANGALORE');
(viii) SELECT DISTINCT CNO FROM  TRANSACTION;

Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii), which are based on the tables
                                        TRAINER 

                                                COURSE       

(i) Display the Trainer Name, City & Salary in descending order of their Hiredate.
(ii) To display the TNAME and CITY of Trainer who joined the Institute in the month of December 2001
(iii) To displayTNAME, HIREDATE, CNAME, STARTDATE from tables TRAINER and COURSE of all those courses whose FEES is less than or equal to 10000.
(iv) To display number of Trainers from each city.
(v) SELECT TID, TNAME FROM TRAINER WHERE CITY NOT IN ('DELHT','MUMBAI');
(vi) SELECT DISTINCT TID FROM COURSE;
(vii) SELECT TID, COUNT("), MIN (FEES) FROM COURSE, GROUP BY TID HAVING COUNT(") >1;
(viii) SELECT COUNT("), SUM(FEES) FROM COURSE WHERE STARTDATE < '2018-09-15';