Customer Equipment equipment Code Loan id name id name equipment Code e startDate returnDate H description RentalRatePerDay address contact dateofBirth occupation DamageReport reportId damageType (iii) Create a view named CustomerSummary with details of each customer, the number of equipment rented, the total amount of rental collected thus far and the number of damages caused by customer and not due to wear and tear. LEIE Name Address Contact DateOfBirth Occupation Number of Equipment Rented Total Rert NumDamage F32J Cherles Toles S8 3F Damien Low sa56F Audrey Ng S45G Betsey Tan 99 34J Peter Lee s ATSZ Ali Bin Mohd Hassan 10 Clomons Road 91239123 10-07-1997 IT Programmor 0 S7 23 Haig Road 92142331 15-03-1976 Teacher 20.00 5 Still Rond 2 88128833 05-07-1985 Teacher 16.00 10 Bedok Road 82138213 23-01-1988 Nurse 3 150.00 1 4 2 Jalan Eunos 98981212 12-05-1990 Cartoorist 2 4.00 8 Jalan Melayu 97589758 04-03-1991 Student 24.00 0.00 7 575J Ravi SIO Ramasamy 12 Jurong Road 82223333 12-08-1998 Personal Trainer 0 0.00 (iv) Use the CustomerSummary view to find the average rental per loan for the customer with the most number of loans. Do not hardcode any value and do not assume that the loan table is non-empty or that there is one row of result as in general, there may be more than one customers with the most number of loans. name contact Number of Equipment Rented Total Rent Average Rental for biggest customer NumDamage 1 Audrey Ng 82138213 3 150.00 50.00

I am having trouble with Tasks 10-12 Task 10: List all the tables contained within the system catalog, but only display the first 10 records with a TABLE_TYPE of SYSTEM VIEW. Task 11: List all the columns contained within the system catalog, but only display the first 11 records that are in the KimTay TABLE_SCHEMA.  Task 12: List all the views contained within the system catalog, but only display the first 12 records.   I have done Tasks 1-9 Here is the formula for Tasks 1-9 TASK 1.   CREATE VIEW MAJOR_CUSTOMER AS SELECT CUST_ID,FIRST_NAME,LAST_NAME, BALANCE, CREDIT_LIMIT, REP_ID FROM CUSTOMER WHERE CREDIT_LIMIT <= 500 ; NEW QUERY SHOW FULL TABLES WHERE table_type = 'VIEW' and tables_in_KimTay = 'MAJOR_CUSTOMER'   TASK 2.  SELECT CUST_ID,FIRST_NAME,LAST_NAME FROM MAJOR_CUSTOMER WHERE BALANCE > CREDIT_LIMIT ;   TASK 3.  SELECT CUST_ID,FIRST_NAME,LAST_NAME  FROM CUSTOMER WHERE CREDIT_LIMIT <= 500 ;   TASK 4.  CREATE VIEW ITEM_INVOICE AS SELECT C.ITEM_ID AS ITEM_ID,…

SQL Help

SERVICE_ID PROPERTY_ID CATEGORY_NUMBER OFFICE_ID DESCRIPTION STATUS EST_HOURS SPENT_HOURS NEXT_SERVICE_DATE 1 11 2 2 The second bedroom upstairs is not heating up at night. Problem has been confirmed. central heating engineer has been scheduled. 2 1 2019-11-01 2 1 4 1 A new strip light is needed for the kitchen. Scheduled 1 0 2019-10-02 3 6 5 1 The bathroom door does not close properly. Service rep has confirmed issue. Scheduled to be refitted. 3 1 2019-11-09 4 2 4 1 New outlet has been requested for the first upstairs bedroom. (There is currently no outlet). Scheduled 1 0 2019-10-02 5 8 3 2 New paint job requested for the common area (lounge). Open 10 0 NULL 6 4 1 1 Shower is dripping when not in use. Problem confirmed. Plumber has been scheduled. 4 2 2019-10-07 7 2 2 1 Heating unit in the entrance smells like it’s burning. Service rep confirmed the issue to be dust in the heating unit. To be cleaned. 1 0 2019-10-09 8 9 1 2 Kitchen sink does not drain properly. Problem…