Question: Consider the following relational schema for a store's database. The relational schema captures information about the different products, the employees working in the store, the
Consider the following relational schema for a store's database. The relational schema captures information about the different products, the employees working in the store, the customers who purchased products, and the wish lists of these customers. The relational schema also captures the different customer transactions, the purchased product, the employee who helped them, the used credit card, the amount paid, the used discount percentage if any and the transaction date.
Customer: Cid Name, Age, email
Employee: Eid Name, StartDate, Salary, email
Products: Pid Name, Company, ProductType, ReleaseDate
Transaction: Cid Eid, Pid, AmountPaid, CreditCardUsed, Date, DiscountPercentage
WishLists: Eid Pid
Question point
Use the relational schema of the store to develop the following query in SQL: Count the number of customers who purchased laptops product type between and
Question options:
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
