Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started