One of the core assets that need to be managed by a novel healthcare app is the treatments that medical doctors give to their patients. Scenario: Patients visit multiple doctors to seek treatments that might be paid (covered) by relevant health insurance policies provided by heath insurance compa- nies. Each treatment has to be tracked including information about the patient, the doctor, and date. The data requirements of this project are summarized as follows: • Each PATIENT is identified by his/her full name, date of birth, and place of birth. Address and email address are also recorded. • Each DOCTOR is identified by a unique id. The name, email, and specialization are recorded as well. • DOCTORS work at PRACTICES. Each PRACTICE is identified by a unique id. The address, telephone number, and opening hours are also tracked for each PRACTICE. • Each PRACTICE must have at least one DOCTOR. • One DOCTOR might work at multiple PRACTICES at the same time. • When DOCTORS treat PATIENTS, the date of each treatment has to be tracked. • One PATIENT is typically treated by multiple DOCTORS. • A PATIENT could have an insurance policy with an INSURANCE_COMPANY that is identified by its name. Main contact and type of instance are also tracked.

QuestionsWrite SQL statements that will answer the following four questions based onthe following tables.1. Find suppliers (company name, country and city) whose country isAustralia or whose city is Paris.2. Compute the extended price for each order. Extended price is obtained bymultiplying unit price by quantity (from Order Details table). Show order id,product name and extended price. Sort the results by product name inascending order.3. List products ids and product names of discontinued confection productsthat are still held in stock. (Confection products are those that have"Confections" as category name.)4. Find the total quantity of each product ordered within each category.Display the category id, category name, product name and total quantity.     Hints:The MONTH(DateField) function can be used to evaluate criteria about the month portion of adate field.The FORMAT(DateField) function can be used to return the month names.The SELECT statement has several options that can be used…

Consider a database, containing a table called info. The table info contains 4 columns first name (of type text), last.name (of type text), birth..year (of type integer), and occupation (of type text). You may assume that the table info is not empty and that all entries are properly entered so that the following questions can be answered. Give the SQL command to a) sort the entries according to the year of birth in ascending order b) return all entries of persons that work as a "pilot" c) return all entries of persons that are were born before 1990 d) add person John Doe, born in 1985, and works as a cook to table info

What is the primary distinction between aggregate and composition? Provide a succinct explanation.