CAN ADD A PRICE FIELD IN CAR TABLE

Customer CustomerID CustomerName CustomerGender CustomerEmail CustomerPhone Vendor TransactionHeader Staff VendorID TransactionID StaffID VendorName StaffID StaffName VendorEmail VendorID StaffGender VendorPhone CustomerID StaffEmail TransactionDate StaffAddress StaffPhone CarTypeID Car Transaction Detail CarTypeID Carld TransactionID TypeName CarTypeID CarlD CarPower Quantity 1. Display CustomerName, StaffName, and Total Transaction (obtained from the total number of sales) for every sales which occurs in April and Customer whose name is more than 1 word. 2. Display CarTypeName and Total Price (obtained from Purchase Price times Quantity and begins with $') for every type which name contains 'o' and Total Price is greater than 12000. 3. Display Date (obtained from PurchaseDate in dd Mon yyyy' format), VendorName, Total Car ( obtained from the count of car), and Total Quantity (obtained from the sum of quantity of all products) for every purchase transaction which was sold by a vendor whose name has more than 4 characters and the transaction occurs in March. 4. Display StaffName, CarName, Total Car (obtained from the count of car), Total Price (obtained from Sales Price times Quantity and begins with '$ ') for every transaction which handled by a Staff whose gender is Female and Total Car is more than 1 car, then sort the result based on Total Price in Descending. 5. Display VendorName, VendorEmail, VendorAddress, CarName, and CarPower (ends with ' Horse Power') for every Vendor who sells the cheapest car and Vendor Address starts with 'C' characters, then sort the result based on VendorName in Ascending order. The duplicate data must be displayed once. (alias subquery)