Using the results of the preceding command as a guide, compile a complete inventory of all sales to individual clients. In this case, we may sort the data by invoice number, client code, and product description. What are the names of the services (INVOICE, LINE, and PRODUCT) that you need to register for?

Task 1: ' The Car Maintenance team wanted to ensure that the default price of the maintenance actions should not be empty and 0 instead if not specified. Alter the MAINTENANCE_TYPES table created in Chapter 8, Activity 1 to set the default MAINTENANCE_PRICE to 0.   ANSWER IN MYSQL PLEASE

Task 6: The StayWell marketing team wants to send mail to all residents. You need to return the first name and surname of all the residents combined as NAME, with their addresses named ADDRESS. However, the address should be retrieved from the PROPERTY table for residents. Task   Retrieve the mailing address (first name, surname, and address) for each resident.   Task 7: The development team wants to add new residents and new service requests to StayWell without checking the latest IDs and manually incrementing it. Therefore, you need to alter the RESIDENTS table and change the RESIDENT_ID field to an auto-incremented field of type SMALLINT.     Alter the RESIDENTS table and change the ID field to an auto-incremented field. Task 8: The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table. Task   Add Yigit…

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. Below is the closest I have gotten to the expected results but I only need the first 10 records displayed: SELECT TABLE_CATALOG,TABLE_SCHEMAFROM INFORMATION_SCHEMA.TABLESWHERE (TABLE_SCHEMA ='information_schema');