DST_productsAge (product, ageGroup, numberSold) SELECT productID, count() FROM products, cartsProducts, purchases, members WHERE products.productID=cartsProducts.productID AND cartsProducts.cartID...
DST_productsAge (product, ageGroup, numberSold) SELECT productID, count() FROM products, cartsProducts, purchases, members WHERE products.productID=cartsProducts.productID AND cartsProducts.cartID purchases.cartiD AND purchases. memberlD members.memberlD AND members.dob<<xx/xx/xxxx> AND member.dob>yy/yy/vyyy consider the table DST_productsAge and the SELECT statement below true true true true false - if a customer buys the same product in 2 different carts, this SELECT will consider them together false - the SELECT statement is reading data from the DST_productsAge table false- this SELECT statement collects data on members and guests false - if the SELECT statement collected data weekly, the DOB ranges would have to be changed cach time